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.