Re: COPY error with null date

On Thu, 2008-12-04 at 19:35 -0700, Bill Todd wrote:
> 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.

null as IS 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: ""
>
>
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997