Thread: Creating schema for multiple tables/fields/indices.
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@ameritech.net
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@ameritech.net > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
* 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
Thanks! This looks doable. Sincerely, David Langschied Langschied Consulting Services 25644 Mackinac Roseville, MI 48066 Phone: (586)777-7542 Cell: (248)789-8493 e-mail: dlangschied@ameritech.net ----- Original Message ----- From: "Adam Witney" <awitney@sghms.ac.uk> To: "dlangschied" <dlangschied@Ameritech.Net>; "pgsql-admin" <pgsql-admin@postgresql.org> Sent: Thursday, April 24, 2003 11:40 AM Subject: Re: [ADMIN] 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@ameritech.net > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean.