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
