P100

Postgres CSV export and import

August 03, 2023

CSV file export

Using COPY multiline statement to a file

COPY
    (SELECT
    ...
    ...)
TO STDOUT WITH CSV HEADER DELIMITER ';' \g FILENAME.csv