| From: | Jose Soares <jose(at)sferacarta(dot)com> |
|---|---|
| To: | general <pgsql-general(at)postgresql(dot)org>, hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | \copy problem |
| Date: | 1999-12-16 16:27:34 |
| Message-ID: | 385912F6.88CC2E7F@sferacarta.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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'
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 1999-12-17 00:31:07 | Re: [GENERAL] Czech2ASCII with --mb=Latin2 |
| Previous Message | Robert Davis | 1999-12-16 15:48:21 | Re: [GENERAL] cant create index on decimal column |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1999-12-16 16:29:05 | Re: [HACKERS] Finding corrupt data |
| Previous Message | Zeugswetter Andreas SB | 1999-12-16 16:22:54 | AW: [HACKERS] SELECT ... AS ... names in WHERE/GROUP BY/HAVING |