Re: Issue import (COPY) data by between miss lines

Hi,

2015-05-08 6:41 GMT+02:00 phuongnh2 <phuongnh2(at)vng(dot)com(dot)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.

--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com