Postgres CSV export and import

CSV file export

Using COPY multiline statement to a file

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