Re: COPY error with null date

[Bill Todd <pg@xxxxxxxxxx>]

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. :-(