Conversion of columns during CSV Import

Поиск
Список
Период
Сортировка
От Patrick Schneider
Тема Conversion of columns during CSV Import
Дата
Msg-id 4FED5F2F.1020603@debeka.de
обсуждение исходный текст
Ответы Re: Conversion of columns during CSV Import  (Raymond O'Donnell <rod@iol.ie>)
Re: Conversion of columns during CSV Import  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: Conversion of columns during CSV Import  (Alban Hertroys <haramrae@gmail.com>)
Список pgsql-general
Hello,

is there any possibility to convert special columns during an CSV import
via COPY?
For example:

HELLO;WORLD;9999;011001

9999 should be converted to a character field
011001 to the date 10th January 2001

For the moment the only idea we have is, to import the CSV into a TEMP
table and
perform the conversion by a select from the temp to the target table.

Thanks for any idea.

Regards,

Patrick

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Notiffy problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Notiffy problem