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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
