How to export the resulting data in PostgreSQL to .CSV?

postgresql export-to-csv
junior picture junior · May 8, 2015 · Viewed 18.8k times · Source

I use PostgreSQL 9.4.1

My query:

copy(select * from city) to 'C:\\temp\\city.csv'
copy(select * from city) to E'C:\\temp\\city.csv'

ERROR: relative path not allowed for COPY to file ********** Error **********

ERROR: relative path not allowed for COPY to file SQL state: 42602

Answer

Politank-Z picture Politank-Z · May 8, 2015

As with this case, it seems likely that you are attempting to use copy from a computer other than the one which hosts your database. copy does I/O from the database host machine's local file system only. If you have access to that filesystem, you can adjust your attempt accordingly. Otherwise, you can use the \copy command in psql.

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