| From: | "Victor Yegorov" <viy(at)pirmabanka(dot)lv> |
|---|---|
| To: | "dlangschied" <dlangschied(at)ameritech(dot)net> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Creating schema for multiple tables/fields/indices. |
| Date: | 2003-04-24 15:46:04 |
| Message-ID: | 20030424154604.GD2407@pirmabanka.lv |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
* dlangschied <dlangschied(at)ameritech(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dlangschied | 2003-04-24 15:49:23 | Re: Creating schema for multiple tables/fields/indices. |
| Previous Message | Michael Brusser | 2003-04-24 15:43:26 | Re: GRANT on all tables? |