Export Postgres table to CSV file with headings

Question

Hi

I'm trying to export a PostgreSQL table with headings to a CSV file via commandline, however I get it to export to CSV file but without headings. I need those headings as well. My code looks as follows

COPY products_273 to '/tmp/products_199.csv' delimiters',';

Any help would highly be appreciated

Answer 1

COPY products_273 to '/tmp/products_199.csv' delimiters',' CSV HEADER;

as described in the manual.

Answer 2

There doesn't seem to be a flag to COPY to output the column names. Another way to do this would be to select the column information from the system catalog (pg_catalog), output that to a csv file, run your copy command and finally cat the two files together.

There are numerous export tools on the net though, so you should be able to find a one step script that does this (or write your own in bash or powershell).