CSV Export

To export the data from a table to a CSV file, use the COPY statement:

Query

COPY tbl TO 'output.csv' (HEADER, DELIMITER ',');

The result of queries can also be directly exported to a CSV file:

Query

COPY (SELECT * FROM tbl) TO 'output.csv' (HEADER, DELIMITER ',');

For additional options, see the COPY statement documentation.