Thread

\copy problem

Jose Soares <jose@sferacarta.com> — 1999-12-16T16:27:34Z

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'