Re: loading delimited files

Поиск
Список
Период
Сортировка
От Antti Haapala
Тема Re: loading delimited files
Дата
Msg-id Pine.GSO.4.44.0301220754420.21186-100000@paju.oulu.fi
обсуждение исходный текст
Ответ на Re: loading delimited files  (will trillich <will@serensoft.com>)
Список pgsql-general
> > Are there docs on how to load delimited files into the database?
>
> to see the format. note that ALL fields in the table are
> exported, and should be included on the import, as well (in
> field-definition order, from your create statements).

And again, if using Pg 7.3 you are not even bound to original column
ordering, or are obliged to copy all the columns.

Also check psql command \copy, it's more often the one you need.

--
Antti Haapala
+358 50 369 3535
ICQ: #177673735


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Error at end of pg_dump output (setting sequence number?)
Следующее
От: "Qiao Jian ( Net2Room)"
Дата:
Сообщение: Re: FW: ERROR: Relation "pg_user" does not exist