Re: Import csv file error with double newline
| От | Payal Singh |
|---|---|
| Тема | Re: Import csv file error with double newline |
| Дата | |
| Msg-id | CANUg7LBRPK_dwTeGL2vKEki1aXeXNAQ8wrwSO5=rxCYLPe+EgQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Import csv file error with double newline (phuongnh2 <phuongnh2@vng.com.vn>) |
| Ответы |
Re: Import csv file error with double newline
|
| Список | pgsql-admin |
What's the definition of raw_so6_zingpay2015 ? (\d raw_so6_zingpay2015)
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
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
В списке pgsql-admin по дате отправления: