Crear Script en PosgreSQL 8.3

Forums: 

Buenas noches a todos, quiero crear un script en POSTGRESQL 8.3. Les agradezco me digan cuáles son los pasos. Muchas gracias.

Crear Script en PostgreSQL 8.3

Buenos días, le envío un ejemplo de un script de una base de datos que contiene 21 tablas aproximadamente. Este script lo quiero hacer para la misma base de datos ya que le agregué más tablas quedando esta de 29.

///////////////////////////////////////////////////////////////////////////////////////
EJEMPLO DEL SCRIPT DE LA BASE DE DATOS
///////////////////////////////////////////////////////////////////////////////////////

{\rtf1\ansi\ansicpg1252\deff0\deflang3082{\fonttbl{\f0\fswiss\fcharset0 Arial;}}
{\*\generator Msftedit 5.41.15.1507;}\viewkind4\uc1\pard\f0\fs20 -- Schema: "public"\par
\par
-- DROP SCHEMA public;\par
\par
CREATE SCHEMA public\par
AUTHORIZATION postgres;\par
GRANT ALL ON SCHEMA public TO postgres;\par
GRANT ALL ON SCHEMA public TO public;\par
COMMENT ON SCHEMA public IS 'Standard public schema';\par
\par
-- Table: "Investigador"\par
\par
-- DROP TABLE "Investigador";\par
\par
CREATE TABLE "Investigador"\par
(\par
idinv character(6) NOT NULL,\par
CONSTRAINT "Investigador_pkey" PRIMARY KEY (idinv),\par
CONSTRAINT "Investigador_idinv_fkey" FOREIGN KEY (idinv)\par
REFERENCES persona (idp) MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION\par
) \par
WITHOUT OIDS;\par
ALTER TABLE "Investigador" OWNER TO postgres;\par
\par
-- Table: actividad\par
\par
-- DROP TABLE actividad;\par
\par
CREATE TABLE actividad\par
(\par
idactiv character(2) NOT NULL,\par
nomactv character(50),\par
idfase character(1),\par
vractiv double precision,\par
idproyinv character(6) NOT NULL,\par
CONSTRAINT actividad_pkey PRIMARY KEY (idproyinv, idactiv),\par
CONSTRAINT actividad_idfase_fkey FOREIGN KEY (idfase)\par
REFERENCES fase (idfase) MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION,\par
CONSTRAINT actividad_idproyinv_fkey FOREIGN KEY (idproyinv)\par
REFERENCES "proyectoInvestigacion" ("idproyInv") MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION\par
) \par
WITHOUT OIDS;\par
ALTER TABLE actividad OWNER TO postgres;\par
\par
-- Table: director\par
\par
-- DROP TABLE director;\par
\par
CREATE TABLE director\par
(\par
iddir character(6) NOT NULL,\par
facultad character(2),\par
CONSTRAINT director_pkey PRIMARY KEY (iddir),\par
CONSTRAINT director_facultad_fkey FOREIGN KEY (facultad)\par
REFERENCES programa (idpgma) MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION,\par
CONSTRAINT director_iddir_fkey FOREIGN KEY (iddir)\par
REFERENCES persona (idp) MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION\par
) \par
WITHOUT OIDS;\par
ALTER TABLE director OWNER TO postgres;\par
-- Table: estadoproyecto\par
\par
-- DROP TABLE estadoproyecto;\par
\par
CREATE TABLE estadoproyecto\par
(\par
idestado character(2) NOT NULL,\par
"descEstado" character(30),\par
CONSTRAINT estadoproyecto_pkey PRIMARY KEY (idestado)\par
) \par
WITHOUT OIDS;\par
ALTER TABLE estadoproyecto OWNER TO postgres;\par
\par
-- Table: estudiante\par
\par
-- DROP TABLE estudiante;\par
\par
CREATE TABLE estudiante\par
(\par
idest character(6) NOT NULL,\par
carrera character(2),\par
CONSTRAINT estudiante_pkey PRIMARY KEY (idest),\par
CONSTRAINT estudiante_carrera_fkey FOREIGN KEY (carrera)\par
REFERENCES programa (idpgma) MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION,\par
CONSTRAINT estudiante_idest_fkey FOREIGN KEY (idest)\par
REFERENCES persona (idp) MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION\par
) \par
WITHOUT OIDS;\par
ALTER TABLE estudiante OWNER TO postgres;\par
\par
-- Table: fase\par
\par
-- DROP TABLE fase;\par
\par
CREATE TABLE fase\par
(\par
idfase character(1) NOT NULL,\par
nomface character(60),\par
CONSTRAINT fase_pkey PRIMARY KEY (idfase)\par
) \par
WITHOUT OIDS;\par
ALTER TABLE fase OWNER TO postgres;\par
\par
-- Table: "grupoInv"\par
\par
-- DROP TABLE "grupoInv";\par
\par
CREATE TABLE "grupoInv"\par
(\par
"idgruInv" character(2) NOT NULL,\par
"nomgrupInv" character(40),\par
CONSTRAINT "grupoInv_pkey" PRIMARY KEY ("idgruInv")\par
) -- Table: invgrupo\par
\par
-- DROP TABLE invgrupo;\par
\par
CREATE TABLE invgrupo\par
(\par
"idgrupoInv" character(2) NOT NULL,\par
idinv character(6) NOT NULL,\par
"fchaIngreso" date NOT NULL,\par
CONSTRAINT invgrupo_pkey PRIMARY KEY ("idgrupoInv", idinv, "fchaIngreso"),\par
CONSTRAINT "invgrupo_idgrupoInv_fkey" FOREIGN KEY ("idgrupoInv")\par
REFERENCES "grupoInv" ("idgruInv") MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION,\par
CONSTRAINT invgrupo_idinv_fkey FOREIGN KEY (idinv)\par
REFERENCES "Investigador" (idinv) MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION\par
) \par
WITHOUT OIDS;\par
ALTER TABLE invgrupo OWNER TO postgres;\par
\par
-- Table: invgrupo\par
\par
-- DROP TABLE invgrupo;\par
\par
CREATE TABLE invgrupo\par
(\par
"idgrupoInv" character(2) NOT NULL,\par
idinv character(6) NOT NULL,\par
"fchaIngreso" date NOT NULL,\par
CONSTRAINT invgrupo_pkey PRIMARY KEY ("idgrupoInv", idinv, "fchaIngreso"),\par
CONSTRAINT "invgrupo_idgrupoInv_fkey" FOREIGN KEY ("idgrupoInv")\par
REFERENCES "grupoInv" ("idgruInv") MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION,\par
CONSTRAINT invgrupo_idinv_fkey FOREIGN KEY (idinv)\par
REFERENCES "Investigador" (idinv) MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION\par
) \par
WITHOUT OIDS;\par
ALTER TABLE invgrupo OWNER TO postgres;\par
\par
-- Table: jurado\par
\par
-- DROP TABLE jurado;\par
\par
CREATE TABLE jurado\par
(\par
idjura character(6) NOT NULL,\par
profesion character(2),\par
CONSTRAINT jurado_pkey PRIMARY KEY (idjura),\par
CONSTRAINT jurado_idjura_fkey FOREIGN KEY (idjura)\par
REFERENCES persona (idp) MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION\par
) \par
WITHOUT OIDS;\par
ALTER TABLE jurado OWNER TO postgres;\par
\par
-- Table: "pInvestigacInvestigador"\par
\par
-- DROP TABLE "pInvestigacInvestigador";\par
\par
CREATE TABLE "pInvestigacInvestigador"\par
(\par
idinv character(6) NOT NULL,\par
"idpInv" character(6) NOT NULL,\par
"idgInv" character(2) NOT NULL,\par
idrol character(2) NOT NULL,\par
CONSTRAINT "pInvestigacInvestigador_pkey" PRIMARY KEY (idinv, "idpInv", "idgInv", idrol),\par
CONSTRAINT "pInvestigacInvestigador_idpInv_fkey" FOREIGN KEY ("idpInv")\par
REFERENCES "proyectoInvestigacion" ("idproyInv") MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION,\par
CONSTRAINT "pInvestigacInvestigador_idrol_fkey" FOREIGN KEY (idrol)\par
REFERENCES rol (idrol) MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION\par
) \par
WITHOUT OIDS;\par
ALTER TABLE "pInvestigacInvestigador" OWNER TO postgres;\par
\par
-- Table: persona\par
\par
-- DROP TABLE persona;\par
\par
CREATE TABLE persona\par
(\par
idp character(6) NOT NULL,\par
nomp character(35) NOT NULL,\par
CONSTRAINT idpersona PRIMARY KEY (idp)\par
) \par
WITHOUT OIDS;\par
ALTER TABLE persona OWNER TO postgres;\par
\par
-- Table: producto\par
\par
-- DROP TABLE producto;\par
\par
CREATE TABLE producto\par
(\par
idproy character(6) NOT NULL,\par
idtpro character(2),\par
idprod character(4) NOT NULL,\par
CONSTRAINT producto_pkey PRIMARY KEY (idproy, idprod),\par
CONSTRAINT producto_idtpro_fkey FOREIGN KEY (idtpro)\par
REFERENCES "tipoProducto" (idtprod) MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION\par
) \par
WITHOUT OIDS;\par
ALTER TABLE producto OWNER TO postgres;\par
\par
-- Table: profesion\par
\par
-- DROP TABLE profesion;\par
\par
CREATE TABLE profesion\par
(\par
idprof character(2) NOT NULL,\par
nomprof character(30),\par
CONSTRAINT profesion_pkey PRIMARY KEY (idprof)\par
) \par
WITHOUT OIDS;\par
ALTER TABLE profesion OWNER TO postgres;\par
\par
-- Table: programa\par
\par
-- DROP TABLE programa;\par
\par
CREATE TABLE programa\par
(\par
nompgma character(30),\par
idpgma character(2) NOT NULL,\par
CONSTRAINT facultad_pkey PRIMARY KEY (idpgma)\par
) \par
WITHOUT OIDS;\par
ALTER TABLE programa OWNER TO postgres;\par
\par
-- Table: "proyGrado"\par
\par
-- DROP TABLE "proyGrado";\par
\par
CREATE TABLE "proyGrado"\par
(\par
idproygrad character(6) NOT NULL,\par
idpgma character(2),\par
fchaproy date,\par
CONSTRAINT "proyGrado_pkey" PRIMARY KEY (idproygrad),\par
CONSTRAINT "proyGrado_idpgma_fkey" FOREIGN KEY (idpgma)\par
REFERENCES programa (idpgma) MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION\par
) \par
WITHOUT OIDS;\par
ALTER TABLE "proyGrado" OWNER TO postgres;\par
\par
-- Table: proyecto\par
\par
-- DROP TABLE proyecto;\par
\par
CREATE TABLE proyecto\par
(\par
idproy character(6) NOT NULL,\par
nomproy character(50),\par
"fchaInic" date,\par
"fchaFin" date,\par
"codSubproy" character(6),\par
CONSTRAINT proyecto_pkey PRIMARY KEY (idproy),\par
CONSTRAINT "proyecto_codSubproy_fkey1" FOREIGN KEY ("codSubproy")\par
REFERENCES proyecto (idproy) MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION\par
) \par
WITHOUT OIDS;\par
ALTER TABLE proyecto OWNER TO postgres;\par
\par
\par
- Table: "proyectoInvestigacion"\par
\par
-- DROP TABLE "proyectoInvestigacion";\par
\par
CREATE TABLE "proyectoInvestigacion"\par
(\par
"idproyInv" character(6) NOT NULL,\par
idgrupo character(2),\par
CONSTRAINT "proyectoInvestigacion_pkey" PRIMARY KEY ("idproyInv"),\par
CONSTRAINT "proyectoInvestigacion_idproyInv_fkey" FOREIGN KEY ("idproyInv")\par
REFERENCES proyecto (idproy) MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION,\par
CONSTRAINT "proyectoInvestigacion_idproyInv_fkey1" FOREIGN KEY ("idproyInv")\par
REFERENCES "grupoInv" ("idgruInv") MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION\par
) \par
WITHOUT OIDS;\par
ALTER TABLE "proyectoInvestigacion" OWNER TO postgres;\par
\par
-- Table: "proygdoTipoproy"\par
\par
-- DROP TABLE "proygdoTipoproy";\par
\par
CREATE TABLE "proygdoTipoproy"\par
(\par
idproygrad character(6) NOT NULL,\par
idtpg character(2) NOT NULL,\par
fchatpg date,\par
"idEstado" character(2) NOT NULL,\par
CONSTRAINT "proygdoTipoproy_pkey" PRIMARY KEY (idproygrad, idtpg, "idEstado"),\par
CONSTRAINT "proygdoTipoproy_idEstado_fkey" FOREIGN KEY ("idEstado")\par
REFERENCES estadoproyecto (idestado) MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION,\par
CONSTRAINT "proygdoTipoproy_idtpg_fkey" FOREIGN KEY (idtpg)\par
REFERENCES tproygrado (idtpg) MATCH SIMPLE\par
ON UPDATE NO ACTION ON DELETE NO ACTION\par
) \par
WITHOUT OIDS;\par
ALTER TABLE "proygdoTipoproy" OWNER TO postgres;\par
\par
-- Table: rol\par
\par
-- DROP TABLE rol;\par
\par
CREATE TABLE rol\par
(\par
idrol character(2) NOT NULL,\par
descrol character(30),\par
CONSTRAINT rol_pkey PRIMARY KEY (idrol)\par
) \par
WITHOUT OIDS;\par
ALTER TABLE rol OWNER TO postgres;\par
\par
-- Table: "tipoProducto"\par
\par
-- DROP TABLE "tipoProducto";\par
\par
CREATE TABLE "tipoProducto"\par
(\par
idtprod character(2) NOT NULL,\par
desctpro character(40),\par
CONSTRAINT "tipoProducto_pkey" PRIMARY KEY (idtprod)\par
) \par
WITHOUT OIDS;\par
ALTER TABLE "tipoProducto" OWNER TO postgres;\par
\par
-- Table: tproygrado\par
\par
-- DROP TABLE tproygrado;\par
\par
CREATE TABLE tproygrado\par
(\par
idtpg character(2) NOT NULL,\par
desctpg character(30),\par
CONSTRAINT tproygrado_pkey PRIMARY KEY (idtpg)\par
) \par
WITHOUT OIDS;\par
ALTER TABLE tproygrado OWNER TO postgres;\par
\par
\par
WITHOUT OIDS;\par
ALTER TABLE "grupoInv" OWNER TO postgres;\par
\par
\par
}

///////////////////////////////////////////////////////////////////////////////////////////////
FIN DEL SCRIPT
///////////////////////////////////////////////////////////////////////////////////////////////