Home > Archive > PostgreSQL Administration > September 2005 > Trying to copy data.









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Trying to copy data.
Peter Ivarsson

2005-09-23, 3:23 am

I am trying to moving data from a DB2 database, but some rows has ^M in it.
I am changing the ^M to \r\n, but the \r\n is invoked in the string instead of being functional.

The fields are separated with | and quotes with "
This since there could be , in the data, and I'm using

copy schema.table FROM 'file.txt' DELIMITER as '|' NULL as 'NULL' CSV QUOTE as '"';

Any idea on how I should do to solve this?


Regards
Peter Ivarsson



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com