problems using COPY

From: roypgsqlgen(at)xemaps(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: problems using COPY
Date: 2001-09-14 20:31:39
Message-ID: 200109142032.f8EKW5786202@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey guys,

I'm trying to copy in data from a file generated by SQL Server's bcp and for most of my tables I'm not having any problems.

But every once in a while, it doesn't like the datetime values from SQL Server, such as this:
2001-02-16 23:32:51.420

Is there anything wrong with this?

Oh, does anyone know how to deal with the fact that SQL Server bcp doesn't put out the \000 for null values from datetime fields?

Roy.

Browse pgsql-general by date

  From Date Subject
Next Message Eric Ridge 2001-09-14 20:33:28 Re: count of occurences
Previous Message Oliver Elphick 2001-09-14 20:30:01 Re: How to implement transaction in plpgsql?