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 по дате отправления:

Предыдущее
От: "Gurunandan R. Bhat"
Дата:
Сообщение: Difference of Time types changed in 7.2
Следующее
От: Rich Shepard
Дата:
Сообщение: Alternate data location, again