creating tables from a disk file

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

Responses

Browse pgsql-general by date

  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