How to export table as CSV with headings on Postgresql?

postgresql csv export-to-csv heading postgresql-copy

COPY products_273 TO '/tmp/products_199.csv' WITH (FORMAT CSV, HEADER);

as described in the manual.

postgresql csv export-to-csv heading postgresql-copy

From psql command line:

\COPY my_table TO 'filename' CSV HEADER

no semi-colon at the end.

postgresql csv export-to-csv heading postgresql-copy

instead of just table name, you can also write a query for getting only selected column data.

COPY (select id,name from tablename) TO 'filepath/aa.csv' DELIMITER ',' CSV HEADER;

with admin privilege

\COPY (select id,name from tablename) TO 'filepath/aa.csv' DELIMITER ',' CSV HEADER;

CodeHunter