From: phuongnh2 <phuongnh2@vng.com.vn>
To: pgsql-admin@postgresql.org
Subject: Import csv file error with double newline
Date: Wed, 6 May 2015 02:44:21 -0700 (MST)
Message-ID: <1430905461085-5848154.post@n5.nabble.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: phuongnh2@vng.com.vn
Subject: Re: Import csv file error with double newline
In-Reply-To: <1430905461085-5848154.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox