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

From dlangschied
Subject Re: Creating schema for multiple tables/fields/indices.
Date
Msg-id 01b901c30a79$14170780$6401a8c0@lcshost
Whole thread Raw
In response to Re: Creating schema for multiple tables/fields/indices.  (Adam Witney <awitney@sghms.ac.uk>)
List pgsql-admin
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.


pgsql-admin by date:

Previous
From: "Victor Yegorov"
Date:
Subject: Re: Creating schema for multiple tables/fields/indices.
Next
From: Jeff Boes
Date:
Subject: How to suppress errors from postmaster log?