creating tables from a disk file

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?