Re: Can't copy empty value to datatype 'timestamp' - Mailing list pgsql-general

From Jon Thorson
Subject Re: Can't copy empty value to datatype 'timestamp'
Date
Msg-id 1042096208.12492.32.camel@ulysses.darkgeek.com
Whole thread Raw
In response to Re: Can't copy empty value to datatype 'timestamp'  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
On Thu, 2003-01-09 at 00:59, Stephan Szabo wrote:
> By default empty string is not null for copying (since you might want to
> insert an empty text string, etc).  You can change the sequence that is
> considered null into an empty string however,
>  copy ... delimiter '|' null '';

That did it.  I didn't know I could define null as something else when
copying data.  I'll have to examine the docs more carefully next time.

Thanks for the help!

-j



pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Can't copy empty value to datatype 'timestamp'
Next
From: "Thomas T. Thai"
Date:
Subject: dropping template1