COPY FROM and multiple null strings

Поиск
Список
Период
Сортировка
От Angva
Тема COPY FROM and multiple null strings
Дата
Msg-id 1172856401.934168.17550@n33g2000cwc.googlegroups.com
обсуждение исходный текст
Ответы Re: COPY FROM and multiple null strings  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general
Hi,

I've run into a little snag in my data loads, and I come seeking
advice before I resort to an ugly workaround...

I have a function which runs COPY FROM several times. My problem is
that my data provider uses symbols to represent nulls - there is a
different symbol for each different data type. For instance a null
date would be '1900-01-01' and a null string would be '#'.  Is there
any way to define multiple null strings in the COPY FROM command?

As always, any suggestions would be much appreciated.

Thanks,
Mark


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

Предыдущее
От: clark@knowideas.com
Дата:
Сообщение: How Can I set a non standard date format?
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: How Can I set a non standard date format?