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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
