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

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)

--
View this message in context: http://postgresql.nabble.com/Issue-import-COPY-data-by-between-miss-lines-tp5848263p5848403.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.