Re: Can't copy empty value to datatype 'timestamp'

From: Jon Thorson <oinos(at)darkgeek(dot)com>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can't copy empty value to datatype 'timestamp'
Date: 2003-01-09 07:10:08
Message-ID: 1042096208.12492.32.camel@ulysses.darkgeek.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas T. Thai 2003-01-09 07:14:47 dropping template1
Previous Message Stephan Szabo 2003-01-09 06:59:02 Re: Can't copy empty value to datatype 'timestamp'