i am using copy statement like this
copy mytable(xx,xx,xxx) from stdin with DELIMITER '|';
x|xx|xxxx
\.
copy mytable(xx,xx,xxx) from stdin with DELIMITER '|';
1|11|1111
\.
copy mytable(xx,xx,xxx) from stdin with DELIMITER '|';
1|22|222222
\.
after every record i am specifying an end marker
is there any possibility to have only one end marker i.e at the end of last record like this
copy mytable(xx,xx,xxx) from stdin with DELIMITER '|';
x|xx|xxxx
copy mytable(xx,xx,xxx) from stdin with DELIMITER '|';
1|11|1111
copy mytable(xx,xx,xxx) from stdin with DELIMITER '|';
1|22|222222
\.
if i use only one end-copy-marker i.e at the end of lat record
i am getting an error like this
"invalid input syntax for integer"" "
CONTEXT:copy mytable,line 2,coloumn x:" "
help me solving this problem