src/test/regress/expected/bfv_copy.source

CREATE TABLE copy_converse_varify_error(a int, b text);
COPY copy_converse_varify_error FROM '@abs_srcdir@/data/copy_converse_varify_error.data'
WITH(FORMAT text, delimiter '|', "null" E'\\N', newline 'LF', escape 'OFF')
LOG ERRORS SEGMENT REJECT LIMIT 10 ROWS;
NOTICE:  found 5 data formatting errors (5 or more input rows), rejected related input data
SELECT * FROM copy_converse_varify_error;
 a |      b      
---+-------------
 1 | 
 4 | aabbccdd
 7 | 123aabbccdd
(3 rows)

DROP TABLE copy_converse_varify_error;
CREATE TABLE copy_eol_on_nextrawpage(b text);
COPY copy_eol_on_nextrawpage FROM '@abs_srcdir@/data/eol_on_next_raw_page.data'
WITH(FORMAT text, delimiter '|', "null" E'\\N', newline 'LF', escape 'OFF')
LOG ERRORS SEGMENT REJECT LIMIT 10 ROWS;
NOTICE:  found 1 data formatting errors (1 or more input rows), rejected related input data
SELECT count(*) FROM copy_eol_on_nextrawpage;
 count 
-------
    15
(1 row)

DROP TABLE copy_eol_on_nextrawpage;