Re: using copy to load odd characters

Поиск
Список
Период
Сортировка
От Francois Suter
Тема Re: using copy to load odd characters
Дата
Msg-id 961F31CA-F8CC-11D7-B8D9-000393427520@monpetitcoin.com
обсуждение исходный текст
Ответ на Re: using copy to load odd characters  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
Список pgsql-general
> Depends on what data type the column is supposed to have.  Character
> data
> types cannot contain null bytes.  The type bytea can store arbitrary
> binary data.  It requires you to escape null bytes so '\\000'.

When you dump some data using pg_dump, null fields are represented as
\N. Maybe you can try that. Hope that helps.

---------------
Francois

Home page: http://www.monpetitcoin.com/

"Would Descartes have programmed in Pascal?" - Umberto Eco

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

Предыдущее
От: Paul Serby
Дата:
Сообщение: "select count(*) from contacts" is too slow!
Следующее
От: "Nigel J. Andrews"
Дата:
Сообщение: Re: "select count(*) from contacts" is too slow!