| From: | Bill Todd <pg(at)dbginc(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | COPY error with null date |
| Date: | 2008-12-05 02:35:54 |
| Message-ID: | 4938938A.2090409@dbginc.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Using 8.3.3 I am trying to import a CSV file using the following copy
command.
copy billing.contact from 'c:/export/contact.csv'
with delimiter as ','
null as ''
csv quote as '"';
The following record record causes an error because the third field, "",
is a null date and causes the error following the record. How can I
change the copy command above so that a null date or number will be
imported as null? I do not care if empty strings are imported as an
empty string or a null.
Bill
"IASAcctSys","09/09/1995","",...
ERROR: invalid input syntax for type date: ""
CONTEXT: COPY contact, line 6, column date: ""
********** Error **********
ERROR: invalid input syntax for type date: ""
SQL state: 22007
Context: COPY contact, line 6, column date: ""
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2008-12-05 04:30:56 | Re: COPY error with null date |
| Previous Message | Scott Marlowe | 2008-12-05 01:30:07 | Re: Job scheduling in Postgre |