Re: Creating schema for multiple tables/fields/indices.

If you have the CREATE statements all written out in one file (eg
create_stuff.sql)

psql <dbname> <username> < create_stuff.sql

Or you could connect with psql and type

\i create_stuff.sql

> 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?
>
> Sincerely,
>
> David Langschied
> Langschied Consulting Services
> 25644 Mackinac
> Roseville, MI 48066
>
> Phone: (586)777-7542
> Cell: (248)789-8493
> e-mail: dlangschied(at)ameritech(dot)net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.