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