importing a pre sql db

Поиск
Список
Период
Сортировка
От SierraAdm@aol.com
Тема importing a pre sql db
Дата
Msg-id d8dec90e.35c7b78e@aol.com
обсуждение исходный текст
Ответы Re: [SQL] importing a pre sql db
Re: [SQL] importing a pre sql db
Список pgsql-sql
  I have, as user postgres, created the database wc_fields via createdb.
  Now I wish to create some tables.
  The man pages - man copy - tell me how to copy values.
  How do I set up my table definitions from an external file?
  I would like to convert my existing table definition which is in the form
  database wc_fields
  file wc_members
  field wc_last_name  type character length 20
  ...  more such fields ...
  I can convert that to
    create table wc_members  (
      wc_last_name  char(20),
      ...  more such ...  )
  How do I get it in as the table definition?
  After that I can edit existing data and use the copy from command .
  Now is this a novice question or an sql question -
  that is why I posted in two places.

В списке pgsql-sql по дате отправления:

Предыдущее
От: chris yambo
Дата:
Сообщение: subscribe pgsql-sql
Следующее
От: "William McCracken"
Дата:
Сообщение: Pg.pm on NT