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

Поиск
Список
Период
Сортировка
От Jon Thorson
Тема Re: Can't copy empty value to datatype 'timestamp'
Дата
Msg-id 1042096208.12492.32.camel@ulysses.darkgeek.com
обсуждение исходный текст
Ответ на Re: Can't copy empty value to datatype 'timestamp'  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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 по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Can't copy empty value to datatype 'timestamp'
Следующее
От: "Thomas T. Thai"
Дата:
Сообщение: dropping template1