Skip site navigation (1) Skip section navigation (2)

Trying to copy data.

From: "Peter Ivarsson" <peter(dot)ivarsson(at)onskefoto(dot)se>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Trying to copy data.
Date: 2005-09-16 22:47:26
Message-ID: E1EGOzJ-0002mb-00@mailbox.tripnet.se (view raw or flat)
Thread:
Lists: 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 


pgsql-admin by date

Next:From: Marcin GiedzDate: 2005-09-17 07:49:52
Subject: Backup issue
Previous:From: cbeahm@gmail.comDate: 2005-09-16 19:15:23
Subject: Contraint Trigger Permissions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group