creating tables from a disk file
От | Rich Shepard |
---|---|
Тема | creating tables from a disk file |
Дата | |
Msg-id | Pine.LNX.4.44.0202190754130.1380-100000@salmo.appl-ecosys.com обсуждение исходный текст |
Ответы |
creating tables from a disk file
|
Список | 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@appl-ecosys.com http://www.appl-ecosys.com
В списке pgsql-general по дате отправления: