Re: Issue import (COPY) data by between miss lines - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: Issue import (COPY) data by between miss lines
Date
Msg-id CAECtzeXwoxcahDDRvEok3P=2F5phQJ4fXxxCwt=+gTwn6R4QyQ@mail.gmail.com
Whole thread Raw
In response to Re: Issue import (COPY) data by between miss lines  (phuongnh2 <phuongnh2@vng.com.vn>)
List pgsql-admin
Hi,

2015-05-08 6:41 GMT+02:00 phuongnh2 <phuongnh2@vng.com.vn>:
Hi Admin,
How to config postgres to result below ??

 CREATE TEMP TABLE foo (a bigint, b text);
-- input_file.txt --

 1      one
 2
 3      three   111
 four    4
 5      five
 error logging off
 COPY foo FROM 'input_file.txt';

 ERROR:  missing data for column "b"
 CONTEXT:  COPY foo, line 2: "2"

skip bad rows
 --skip bad rows
 COPY foo FROM 'input_file.txt' (ERROR_LOGGING,
ERROR_LOGGING_SKIP_BAD_ROWS);
 SELECT * FROM foo;

  a |  b
 ---+------
  1 | one
  5 | five
 (2 rows)


You can't use COPY do to that. That feature does not exist with PostgreSQL itself. pgloader should be able to do that, you should take a look.


--

pgsql-admin by date:

Previous
From: "Muthusamy, Sivaraman"
Date:
Subject: How to VACUUM_FULL / clean / truncate of pg_largeobject without (much) downtime?
Next
From: Nathan Aherne
Date:
Subject: SSL and MD5 passwords