Hi,
--
2015-05-08 6:41 GMT+02:00 phuongnh2 <phuongnh2@xxxxxxxxxx>:
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.
--
