Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Yq0h3-0006NH-5i for pgsql-admin@arkaria.postgresql.org; Wed, 06 May 2015 14:53:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Yq0h2-0006zQ-LL for pgsql-admin@arkaria.postgresql.org; Wed, 06 May 2015 14:53:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Ypvta-0002MG-5f for pgsql-admin@postgresql.org; Wed, 06 May 2015 09:45:38 +0000 Received: from mwork.nabble.com ([162.253.133.43]) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1Ypvsx-0006ZS-JF for pgsql-admin@postgresql.org; Wed, 06 May 2015 09:45:34 +0000 Received: from msam.nabble.com (unknown [162.253.133.85]) by mwork.nabble.com (Postfix) with ESMTP id 702051D4EAA8 for ; Wed, 6 May 2015 02:45:08 -0700 (PDT) Date: Wed, 6 May 2015 02:44:21 -0700 (MST) From: phuongnh2 To: pgsql-admin@postgresql.org Message-ID: <1430905461085-5848154.post@n5.nabble.com> Subject: Import csv file error with double newline MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_187244_141711696.1430905461088" X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ------=_Part_187244_141711696.1430905461088 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all,help me !I have scriber log file (text file), content inside file below:201505012202210SE1457863,201505010104009,,ng0022119089,awttar7p6,A832624640,VLMB,1,ng0022119089,500000,1,201505010104009,2015-05-01 22:02:27201505012202220SE2778097,201505010104010,,PE0020947080,YZBBLXWDX,S1915202387,VLMB,1,PE0020947080,100000,1,201505010104010,2015-05-01 22:02:28201505012203570SE1363941,201505010104047,,WC0019824617,9NXZXPW9K,S1915202387,VLMB,1,WC0019824617,20000,1,201505010104047,2015-05-01 22:04:03postgresSQL: COPY raw_so6_zingpay2015 FROM '/data/scribe_log/so6/2015-04-15/ZingPay_VLMB_BEZPay-2015-04-15_00012' WITH (FORMAT CSV, HEADER, DELIMITER E',', NULL '\n');ERROR: missing data for column "dbgtransid"CONTEXT: COPY raw_so6_zingpay2015, line 2: ""what is option to double newline ??thanks,phuongnh2 -- View this message in context: http://postgresql.nabble.com/Import-csv-file-error-with-double-newline-tp5848154.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. ------=_Part_187244_141711696.1430905461088 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, help me ! I have scriber log file (text file), content inside file below: 201505012202210SE1457863,201505010104009,,ng0022119089,awttar7p6,A832624640,VLMB,1,ng0022119089,500000,1,201505010104009,2015-05-01 22:02:27 201505012202220SE2778097,201505010104010,,PE0020947080,YZBBLXWDX,S1915202387,VLMB,1,PE0020947080,100000,1,201505010104010,2015-05-01 22:02:28 201505012203570SE1363941,201505010104047,,WC0019824617,9NXZXPW9K,S1915202387,VLMB,1,WC0019824617,20000,1,201505010104047,2015-05-01 22:04:03 postgresSQL: COPY raw_so6_zingpay2015 FROM '/data/scribe_log/so6/2015-04-15/ZingPay_VLMB_BEZPay-2015-04-15_00012' WITH (FORMAT CSV, HEADER, DELIMITER E',', NULL '\n'); ERROR: missing data for column "dbgtransid" CONTEXT: COPY raw_so6_zingpay2015, line 2: "" what is option to double newline ?? thanks, phuongnh2
View this message in context: Import csv file error with double newline
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
------=_Part_187244_141711696.1430905461088--