Re: creating tables from a disk file

Rich Shepard <rshepard@appl-ecosys.com> 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?

A little reading of the docs would have solved your problem.  ;)

$ psql -f <file>

or

$ psql
> \i <file>

Is this not what you are looking for?

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863