The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-copy.html
Description:
The example shown for COPY FROM is very basic and doesn't show how to use
any of the options -- which have tricky syntax that seems to trip up a
number of people.
Some suggestions:
COPY my_table FROM my_table.csv WITH (FORMAT csv, ESCAPE '\', HEADER,
ENCODING win1251);
COPY tbl (id, color) FROM STDIN WITH (FORMAT text, ENCODING utf8, DELIMITER
'|', FREEZE);
1|Brown
2|Purple
3|Maroon
Thanks,
--Joe
