| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | inc(at)piksel(dot)ee |
| Subject: | Exsamples for COPY |
| Date: | 2020-02-01 07:44:24 |
| Message-ID: | 158054306426.19850.827178569802884479@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Doc comments form | 2020-02-01 08:33:38 | pg_dump, --exclude-table-data |
| Previous Message | Daniel Gochin | 2020-01-30 12:55:30 | Re: pg_dump documentation page |