export table to csv on postgres

postgresql csv export-to-csv
Luba Weissmann picture Luba Weissmann · Dec 19, 2013 · Viewed 25.8k times · Source

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.

Answer

marvinorez picture marvinorez · Dec 19, 2013

Use psql and redirect stream to file:

psql -U <USER> -d <DB_NAME> -c "COPY <YOUR_TABLE> TO stdout DELIMITER ',' CSV HEADER;" > file.csv

Related questions

How to export table as CSV with headings on Postgresql?

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' …

Read More
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
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