Re: valid NULL DATE value - Mailing list pgsql-general

From Len Morgan
Subject Re: valid NULL DATE value
Date
Msg-id 002301c12c98$a86f4480$0908a8c0@bstx.cc
Whole thread Raw
In response to resin-cmp, apache1.3.20, ultradev4, and postgresql7.0 problems  (tomasz konefal <twkonefal@yahoo.ca>)
List pgsql-general
> I am importing via pgaccess a text file from another non-postgres
> database and the NULL DATE values are written like 00/00/00.
>
> What I have tried is replacing 00/00/00 by 9/9/1999 and setting the
> style to european and I am getting 'can't parse /9/1999' errors.

Try replacing 00/00/00 with NULL in the text file.  If the text file is
organized to be read by the COPY command, then use \N instead.

len morgan


pgsql-general by date:

Previous
From: Tony Grant
Date:
Subject: valid NULL DATE value
Next
From: "Oliver Elphick"
Date:
Subject: Re: valid NULL DATE value