The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-copy.html Description:
It would be benefitial to add some more complex (real-life) exsamples to new syntax Eg: Reading TAB-delimited UTF8 CSV file residing in local machine and Postrge is installed into local machice (windows): copy City (city_name, city_code) from 'C:\Temp\city_data.csv' (FORMAT csv, HEADER true, DELIMITER E'\t', QUOTE '"', ENCODING 'UTF-8'); Writing semicolon-delimited CSV UTF-8 file to server temporary folder forcing zip code numbers to quote: copy (select id, street_name, zip_code from delivery_point) to '/tmp/bi/place.csv' (format csv, header true, delimiter ';', quote '"', FORCE_QUOTE (zip_code), encoding 'UTF-8'); Cheers