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

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Can't copy empty value to datatype 'timestamp'
Date: 2003-01-09 06:56:28
Message-ID: 3E1D6A74.17800.364FCB1@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9 Jan 2003 at 0:50, Jon Thorson wrote:

> I'm running into a problem importing data into my database. What seems
> to be the issue is an empty value on a field defined as 'timestamp'. In
> psql I'm using the following command to import the data:

Is that last field in the row? Is the text dump file in unix \n format or dos
one.

Copy will choke on dos mode files. There are plenty of ways to convert the
files from one format to another.

HTH

Bye
Shridhar

--
Not one hundred percent efficient, of course ... but nothing ever is. -- Kirk,
"Metamorphosis", stardate 3219.8

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-01-09 06:59:02 Re: Can't copy empty value to datatype 'timestamp'
Previous Message Jon Thorson 2003-01-09 06:50:58 Can't copy empty value to datatype 'timestamp'