Re: COPY error with null date

Joshua D. Drake wrote:

On Fri, 2008-12-05 at 12:00 -0700, Bill Todd wrote: 

Joshua D. Drake wrote:    

On Thu, 2008-12-04 at 19:35 -0700, Bill Todd wrote:     

null as IS NULL results in the following error.

ERROR:  syntax error at or near "is"
LINE 5: null as is null               ^

********** Error **********

ERROR: syntax error at or near "is"
SQL state: 42601
Character: 109

Any other suggestions?   

COPY foo FROM '/tmp/bar' NULL as 'NULL'
 

copy billing.contact from 'c:/export/contact.csv'
with csv delimiter as ','
null as 'NULL'
quote as '"';

produces the same error. I am beginning to suspect this is impossible. :-(