X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AFAD3D8282 for ; Fri, 16 Sep 2005 19:47:24 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94151-06 for ; Fri, 16 Sep 2005 22:47:21 +0000 (GMT) Received: from mx1.tripnet.se (mx1.tripnet.se [217.28.202.24]) by svr1.postgresql.org (Postfix) with ESMTP id 9A9FFD81BB for ; Fri, 16 Sep 2005 19:47:19 -0300 (ADT) Received: from mailbox.tripnet.se [217.28.202.27] by mx1.tripnet.se with esmtp (Exim 3.35 #1 (Debian)) id 1EGOzJ-00029X-00; Sat, 17 Sep 2005 00:47:21 +0200 Received: from (peterbuilt) [212.214.206.29] by mailbox.tripnet.se with asmtp (Exim 3.35 #1 (Debian)) id 1EGOzJ-0002mb-00; Sat, 17 Sep 2005 00:47:21 +0200 Reply-To: From: "Peter Ivarsson" To: Subject: Trying to copy data. Date: Sat, 17 Sep 2005 00:47:26 +0200 Organization: =?utf-8?Q?=C3=96nskefoto_AB?= MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000A_01C5BB21.60023740" X-Mailer: Microsoft Office Outlook, Build 11.0.6353 Thread-Index: AcW7EJv1Sgdol1MBQBmVYBHOR/WJ2g== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 Message-Id: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.805 required=5 tests=[HTML_FONT_FACE_CAPS=0.804, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200509/257 X-Sequence-Number: 18994 This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C5BB21.60023740 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable 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. =20 The fields are separated with | and quotes with " This since there could be , in the data, and I'm using=20 =20 copy schema.table FROM 'file.txt' DELIMITER as '|' NULL as 'NULL' CSV = QUOTE as '"'; =20 Any idea on how I should do to solve this? =20 Regards Peter Ivarsson=20 ------=_NextPart_000_000A_01C5BB21.60023740 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable =EF=BB=BF
I am = trying to=20 moving data from a DB2 database, but some rows has ^M in = it.
I=20 am changing the ^M to \r\n, but the \r\n  is invoked in the = string=20 instead of being functional.
 
The fields are separated with | and quotes with=20 "
This = since there=20 could be , in the data, and I'm using
 
copy = schema.table FROM 'file.txt' DELIMITER as '|' NULL as 'NULL' CSV QUOTE = as=20 '"';
 
Any = idea on how=20 I should do to solve this?
 

Regards
Peter Ivarsson

------=_NextPart_000_000A_01C5BB21.60023740--