\copy problem - Mailing list pgsql-hackers

From Jose Soares
Subject \copy problem
Date
Msg-id 385912F6.88CC2E7F@sferacarta.com
Whole thread Raw
Responses Re: [HACKERS] \copy problem
List 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 by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: [HACKERS] SELECT ... AS ... names in WHERE/GROUP BY/HAVING
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] pg_dump --help