Export a PostgreSQL Table to a CSV File

PHOTO

Fri Dec 04 2020 02:12:13 GMT+0000 (Coordinated Universal Time)

Saved by @Campbell

\copy (SELECT * FROM persons) to 'C:\tmp\persons_client.csv' with csv

https://www.postgresqltutorial.com/export-postgresql-table-to-csv-file/

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

Linux

@Campbell

Export a PostgreSQL Table to a CSV File

Browse more snippets >>