Re: Handling NULL dates in "copy from" statement - Mailing list pgsql-general

From Jeff Eckermann
Subject Re: Handling NULL dates in "copy from" statement
Date
Msg-id 20011210172746.61949.qmail@web20805.mail.yahoo.com
Whole thread Raw
In response to Handling NULL dates in "copy from" statement  ("Tim Nelson" <nelsonx@earthlink.com>)
List pgsql-general
The "with null as ''" should work: it does for me.
Are you sure that the field truly is empty, i.e. there
is no nonprintable character lurking in there?

--- Tim Nelson <nelsonx@earthlink.com> wrote:
> Is there a way to handle NULL date fields
> that I am trying to import from another database?
>
> ex:
>
> ...for a table with a single date field that allows
> NULL...
>
> echo "12/31/2000" | psql -c "copy date_tab from
> stdin using delimiters '|' "
> db_name
>
> ...works, but if I use a blank date...
>
> echo "" | psql -c "copy date_tab from stdin using
> delimiters '|' " db_name
>
> ...it fails with "Bad date external
> representation"...
>
> I've tried replacing the empty string with "NULL"
> and adding " with null as
> '' " to no avail.
>
> Any ideas?  Thanks.  Tim
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)


__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com

pgsql-general by date:

Previous
From: Antonio Fiol Bonnín
Date:
Subject: Re: Analyzer for postgresql.log
Next
From: Lamar Owen
Date:
Subject: Re: RedHat6.2 - postgres 7.1.2 lib confusion