How do I export data from Heroku Postgresql to CSV?

Tue, 19 Mar 2019

You can copy data from a Heroku postgres database to your local working directory by running:

heroku pg:sql 
app::DATABASE=> \copy (SELECT * FROM some_table) TO some_table.csv CSV DELIMITER ','

Unless otherwise specified, all code samples and work are published under the MIT license.