From: | Payal Singh <payal(at)omniti(dot)com> |
---|---|
To: | phuongnh2 <phuongnh2(at)vng(dot)com(dot)vn> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Import csv file error with double newline |
Date: | 2015-05-06 15:15:26 |
Message-ID: | CANUg7LBRPK_dwTeGL2vKEki1aXeXNAQ8wrwSO5=rxCYLPe+EgQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)vng(dot)com(dot)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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2015-05-06 15:20:07 | Re: INSERT ... ON CONFLICT UPDATE/IGNORE 4.0 |
Previous Message | phuongnh2 | 2015-05-06 09:44:21 | Import csv file error with double newline |