The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-copy.html Description:
The documentation states that headers are only used for CSV files, but there is a header "PGCOPY" when using a BINARY export. e.g. COPY (SELECT zipfile FROM file_upload) TO PROGRAM 'cat > /tmp/dunc ' (FORMAT binary); Please can we have an example of using COPY (server/plpgsql) to copy a bytea (eg image) column to an image file, unchanged - i.e. no headers.
