From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Creating tables from files |
Date: | 2001-11-07 01:18:36 |
Message-ID: | Pine.LNX.4.33.0111061713260.7325-100000@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Rather embarrassing to have to ask this, but I forget how to do it and I
cannot find the directions in the available docs; I know it's there
somewhere but I'm just not seeing it.
I have a series of 'create table' definitions in a text file. I want to
read this into postgres to create the tables, rather than re-keying them by
hand from within the program. INSERT works on rows and COPY works on values.
What I'm trying to do is create the entire database from a schema worked out
in a file.
I would greatly appreciate a pointer to the proper command and the manual
in which I can read the syntax and, I hope, remember it for the next time.
Thanks,
Rich
Dr. Richard B. Shepard, President
Applied Ecosystem Services, Inc. (TM)
2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
+ 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | rshepard(at)appl-ecosys(dot)com
http://www.appl-ecosys.com
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Earl | 2001-11-07 01:52:44 | Re: Creating tables from files |
Previous Message | Peter Eisentraut | 2001-11-07 01:08:48 | Re: self outer join |