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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general