\copy problem

Поиск
Список
Период
Сортировка
От Jose Soares
Тема \copy problem
Дата
Msg-id 385912F6.88CC2E7F@sferacarta.com
обсуждение исходный текст
Ответы Re: [HACKERS] \copy problem  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Hi all,

I have a problem using \copy to load data into tables.

I have to load data into a table that contains data type fields with
NULL values.
I tried using \N but it doesn't work.
What can I do to insert a null into a data field?

To arrive this conclusion I had to try many solutions because I cannot
understand
the \copy error messages..

What about to have the row number and the error type instead of that...
hygea=> \copy movimentazioni from 4;
pqReadData() --  read() failed: errno=32
Broken pipe
PQendcopy: resetting connection
Copy failed.

Comments!

Jose'

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

Предыдущее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: [HACKERS] SELECT ... AS ... names in WHERE/GROUP BY/HAVING
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] pg_dump --help