Thread: Import csv file error with double newline

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.

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.