creating tables from a disk file - Mailing list pgsql-general

From Lee Kindness
Subject creating tables from a disk file
Date
Msg-id 15474.32598.991337.623234@kelvin.csl.co.uk
Whole thread Raw
In response to creating tables from a disk file  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Simply use psql and redirection...

 createdb database
 psql database < create-tables.sql

Just ensuring your statements are ';' terminated or '\g' terminated,
but not both!

Regards, Lee Kindness.

Rich Shepard writes:
 >   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?

pgsql-general by date:

Previous
From: "Raymond O'Donnell"
Date:
Subject: Re: pg_dump correct version?
Next
From: Doug McNaught
Date:
Subject: Re: creating tables from a disk file