Home > mailing lists

Trying to copy data. - Mailing list pgsql-admin

From	Peter Ivarsson
Subject	Trying to copy data.
Date	September 23, 2005 04:51:50
Msg-id	E1EGOzJ-0002mb-00@mailbox.tripnet.se Whole thread Raw
List	pgsql-admin

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

From: Francis Tiangco
Date: 23 September 2005, 04:48:13
Subject: pgAdmin/pgAgent problems

From: haibin zhang
Date: 23 September 2005, 05:01:19
Subject: The full runtime environment of Mingw for test