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 ','
Questions? Comments? Send them all along to tyler@ogdenstudios.xyz
Want to support the open source work I do? Buy me a coffee.
Unless otherwise specified, all code samples and work are published under the MIT license.