pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedImport csv file error with double newline
3+ messages / 2 participants
[nested] [flat]
* Import csv file error with double newline
@ 2015-05-06 09:44 phuongnh2 <phuongnh2@vng.com.vn>
0 siblings, 1 reply; 3+ messages in thread
From: phuongnh2 @ 2015-05-06 09:44 UTC (permalink / raw)
To: pgsql-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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Import csv file error with double newline
@ 2015-05-06 15:15 Payal Singh <payal@omniti.com>
parent: phuongnh2 <phuongnh2@vng.com.vn>
0 siblings, 1 reply; 3+ messages in thread
From: Payal Singh @ 2015-05-06 15:15 UTC (permalink / raw)
To: phuongnh2 <phuongnh2@vng.com.vn>; +Cc: pgsql-admin
What's the definition of raw_so6_zingpay2015 ? (\d raw_so6_zingpay2015)
Payal Singh,
Database Administrator,
OmniTI Computer Consulting Inc.
Phone: 240.646.0770 x 253
On Wed, May 6, 2015 at 5:44 AM, phuongnh2 <phuongnh2@vng.com.vn> wrote:
> 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
> <http://postgresql.nabble.com/Import-csv-file-error-with-double-newline-tp5848154.html;
> Sent from the PostgreSQL - admin mailing list archive
> <http://postgresql.nabble.com/PostgreSQL-admin-f2076596.html; at
> Nabble.com.
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Import csv file error with double newline
@ 2015-05-07 02:40 phuongnh2 <phuongnh2@vng.com.vn>
parent: Payal Singh <payal@omniti.com>
0 siblings, 0 replies; 3+ messages in thread
From: phuongnh2 @ 2015-05-07 02:40 UTC (permalink / raw)
To: pgsql-admin
raw_so6_zingpay2015 structure
CREATE TABLE raw_so6_zingpay2015
(
Col1 character varying(500),
Col2 character varying(500),
Col3 character varying(500),
Col4 character varying(500),
Col5 character varying(500),
Col6 character varying(500),
Col7 character varying(500),
Col8 character varying(500),
Col9 character varying(500),
Col10 character varying(500),
Co11 character varying(500),
Col13 character varying(500)
) ;
--
View this message in context: http://postgresql.nabble.com/Import-csv-file-error-with-double-newline-tp5848154p5848259.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2015-05-07 02:40 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-05-06 09:44 Import csv file error with double newline phuongnh2 <phuongnh2@vng.com.vn>
2015-05-06 15:15 ` Payal Singh <payal@omniti.com>
2015-05-07 02:40 ` phuongnh2 <phuongnh2@vng.com.vn>
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