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

Creating schema for multiple tables/fields/indices.

From
"dlangschied"
Date:
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


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

From
Adam Witney
Date:
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.


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

From
"Victor Yegorov"
Date:
* 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

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

From
"dlangschied"
Date:
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.