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?
pgsql-admin by date
|Next:||From: Marcin Giedz||Date: 2005-09-17 07:49:52|
|Subject: Backup issue|
|Previous:||From: firstname.lastname@example.org||Date: 2005-09-16 19:15:23|
|Subject: Contraint Trigger Permissions|