From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | creating tables from a disk file |
Date: | 2002-02-19 15:54:35 |
Message-ID: | Pine.LNX.4.44.0202190754130.1380-100000@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have created the database schema as a text file. It contains all the
CREATE TABLE comands with the fields and their constraints. But, I cannot
find a command that will have postgres accept this file and create the
tables for me.
The COPY (\copy) commands are only for data and so is INSERT. CREATE TABLE
does not appear to have an option by which a disk file can be specified.
Is there a way of having the postmaster read the specifications and create
the tables, or do I re-enter them all from within psql?
TIA,
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 | Tom Lane | 2002-02-19 15:58:34 | Re: text vs varchar(n) |
Previous Message | Rich Shepard | 2002-02-19 15:54:05 | Alternate data location, again |