The following bug has been logged on the website:
Bug reference: 17841
Logged by: Stefan Goldener
Email address: stefan(dot)goldener(at)theprosperity(dot)company
PostgreSQL version: 11.16
Operating system: x86_64-pc-linux-gnu
Description:
The COPY command doesn't quote properly e.g.:
COPY (SELECT *, CURRENT_DATE as partitiondate FROM {table}) TO STDOUT WITH
(DELIMITER '|', QUOTE '\"', FORCE_QUOTE *, FORMAT CSV, HEADER)
delivers:
faasdfagdf|"1234"||
as output
so the first column is not quoted properly