Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 7C3C12E0042 for ; Mon, 7 Apr 2008 05:32:13 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 05988-07 for ; Mon, 7 Apr 2008 05:32:10 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web55509.mail.re4.yahoo.com (web55509.mail.re4.yahoo.com [206.190.58.218]) by developer.postgresql.org (Postfix) with SMTP id 51FD52E004F for ; Mon, 7 Apr 2008 05:32:10 -0300 (ADT) Received: (qmail 4781 invoked by uid 60001); 7 Apr 2008 08:32:09 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=M+zUljv6wFXGQ1sdk8lba1e6YxMbgQnD97HszP/o/RcLQKii3zT4z59igF7splqMvkeWvZtPUsoqHUMycoB4y15T6iT1bTyU70BlWMKn3sg/0v6/5lv7WsPKEOA9XCYkXyKA9y4pMUut1+iIZ/25V5WT+3dtuyXCjnFrjzJuVPs=; X-YMail-OSG: SylNtFUVM1kvP7TyTHQo7_DK4qNxEKA07jX2sYnx_ywkaLuJpVF6PoMSL0zRZOAij12ZTeyJlTL3Rb.IjVqgjpzM.AQgt0Y.io7GSZfONr7Wj7zwMqWXPEc1ut6UxQ-- Received: from [220.231.81.133] by web55509.mail.re4.yahoo.com via HTTP; Mon, 07 Apr 2008 01:32:08 PDT X-Mailer: YahooMailRC/902.40 YahooMailWebService/0.7.185 Date: Mon, 7 Apr 2008 01:32:08 -0700 (PDT) From: xuan thang Subject: Import from CSV To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-220511979-1207557128=:4270" Message-ID: <988143.4270.qm@web55509.mail.re4.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200804/60 X-Sequence-Number: 28824 --0-220511979-1207557128=:4270 Content-Type: text/plain; charset=us-ascii Hi, I'm using The PostgresSQL Interactive Terminal In PostgresSQL 8.1.4. When I import a table from csv file by command "copy table from './table.csv' with csv header", DB Engine add a new line sequence (\n) after a new line sequence(\n) in origin data automatically. Example: My data in Employee.csv file: (this file is exported by The PostgresSQL Interactive terminal ) ID Name Address 1 John City (one new line sequence here) Country 2................................................................................. I use The PostgresSQL Interactive terminal to import this csv file to DB by command: "\copy Employee from './Employee.csv' with csv header" After import , I have data in table Employee of Postgres DB. ID Name Address 1 John City (original new line sequence here) (a new line sequence added here automaticaly) Country 2................................................................................. Please help me to import origin data in csv into table. Thanks alot! Xuan Thang. ____________________________________________________________________________________ You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com --0-220511979-1207557128=:4270 Content-Type: text/html; charset=us-ascii
Hi,
I'm using The PostgresSQL Interactive Terminal In PostgresSQL 8.1.4.
When I import a table from csv file by command "copy table from './table.csv' with csv header", DB Engine add a new line sequence (\n) after a new line sequence(\n) in origin data automatically.
Example:
My data in Employee.csv file: (this file is exported by The PostgresSQL Interactive terminal )

ID             Name                                       Address
1               John                                          City (one new line sequence here)
                                                                   Country
2.................................................................................

I use The PostgresSQL Interactive terminal to import this csv file to DB by command:
"\copy Employee from './Employee.csv' with csv header"
After import , I have data in table Employee of Postgres DB.

ID             Name                                       Address
1               John                                          City (original new line sequence here)
                                                                         (a new line sequence added here automaticaly)
                                                                   Country
2.................................................................................

Please help me to import origin data in csv into table.
Thanks alot!
Xuan Thang.




You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. --0-220511979-1207557128=:4270--