How to export table as CSV with headings on Postgresql?

postgresql csv export-to-csv heading postgresql-copy
Elitmiar picture Elitmiar · Jul 13, 2009 · Viewed 444.1k times · Source

I'm trying to export a PostgreSQL table with headings to a CSV file via command line, however I get it to export to CSV file, but without headings.

My code looks as follows:

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

Answer

Milen A. Radev picture Milen A. Radev · Jul 13, 2009 
COPY products_273 TO '/tmp/products_199.csv' WITH (FORMAT CSV, HEADER);

as described in the manual.

Related questions

How to export a PostgreSQL query output to a csv file

I'm having problem exporting my PostgreSQL output from a shell to a csv file. My SQL script is called script.sql. I typed the following command in my shell: psql congress -af script.sql &> filename.csv But when …

Read More
export table to csv on postgres

How can I export a table to .csv in Postgres, when I'm not superuser and can't use the copy command? I can still import the data to postgres with "import" button on the right click, but no export option.

Read More
How to import CSV file data into a PostgreSQL table?

How can I write a stored procedure that imports data from a CSV file and populates the table?

Read More