Re: Creating schema for multiple tables/fields/indices. - Mailing list pgsql-admin

From Victor Yegorov
Subject Re: Creating schema for multiple tables/fields/indices.
Date
Msg-id 20030424154604.GD2407@pirmabanka.lv
Whole thread Raw
In response to Creating schema for multiple tables/fields/indices.  ("dlangschied" <dlangschied@ameritech.net>)
List pgsql-admin
* dlangschied <dlangschied@ameritech.net> [24.04.2003 18:39]:
> I just downloaded postgreSQL.  I have finished the install and everything
> looks okay.  I am now ready to create a db and add tables/fields/indices.  I
> have approx. 100 tables 2,000 fields and 500 indices.  Before I spend an
> ungodly amount of time doing these individually, can I load an entire schema
> via some scripting method?

Do you have structure of your stuff (DDL) as SQL statements somewhere?

If yes, then find how to feed all that stuff to psql (I suggest using `-c'
flag or simply pipe to psql) - see docs.

If no, then you'll have to spent some time on creation of your DB structure.

--

Victor Yegorov

Attachment

pgsql-admin by date:

Previous
From: Michael Brusser
Date:
Subject: Re: GRANT on all tables?
Next
From: "dlangschied"
Date:
Subject: Re: Creating schema for multiple tables/fields/indices.