problems using COPY

Поиск
Список
Период
Сортировка
От roypgsqlgen@xemaps.com
Тема problems using COPY
Дата
Msg-id 200109142032.f8EKW5786202@postgresql.org
обсуждение исходный текст
Список 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
datetimefields? 

Roy.




В списке pgsql-general по дате отправления:

Предыдущее
От: "Oliver Elphick"
Дата:
Сообщение: Re: How to implement transaction in plpgsql?
Следующее
От:
Дата:
Сообщение: Re: How to implement transaction in plpgsql?