COPY FROM needs better example
PG Doc comments form <[email protected]> Wed, 20 Nov 2019 17:55:09 +0000
| Newsgroups | gmane.comp.db.postgresql.devel.documentation |
|---|---|
| Message-ID | <[email protected]> |
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