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 ','
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.