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
