Quoted NULLs with COPY FROM

Поиск
Список
Период
Сортировка
От George Pavlov
Тема Quoted NULLs with COPY FROM
Дата
Msg-id CCB89282FCE1024EA3DCE687A96A51640471F34F@ehost010-6.exch010.intermedia.net
обсуждение исходный текст
Ответы Re: Quoted NULLs with COPY FROM  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
I need to load CSV files that have quotes in data fields that I want to
map to NULLs in the destination table. So if I see ...,"",... that needs
to be mapped to a NULL (in an INTEGER field in this particular case).
Are there any COPY command options that can do that? It seems that PgSQL
COPY expects the NULL to be always unquoted. There is an option (FORCE
NOT NULL) for doing the opposite. How do I specify that the NULLs are
quoted? I am on 8.0.5.

George



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

Предыдущее
От: Michael Glaesemann
Дата:
Сообщение: Re: mac os x compile failure
Следующее
От: Tony Caduto
Дата:
Сообщение: Does this look ethical to you?