On 2012-06-29, Patrick Schneider <patrick.schneider@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
