Re: Conversion of columns during CSV Import

On 2012-06-29, Patrick Schneider <patrick.schneider@debeka.de> wrote:
> 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

do you mean like '9999' (easy) or like '香' or like '✏' (harder)

> 011001 to the date 10th January 2001

I don't think there's any setting you can use to get postgres to
automatically translate 011001 to 10th January 2001 during a csv import

'20010110' would be doable

> 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.

that's probably the best way.

--
⚂⚃ 100% natural