\copy problem

Jose Soares <jose@sferacarta.com>

From: Jose Soares <jose@sferacarta.com>
To: general <pgsql-general@postgresql.org>, hackers <pgsql-hackers@postgresql.org>
Date: 1999-12-16T16:27:34Z
Lists: 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'