Using the Heroku web interface, how do you export a PG database from Heroku into a CSV file?

Question

I am trying to export a CSV file from Heroku's PostGresql database to import it into a MongoDB outside of Heroku. Does anyone know of any good way of exporting a CSV file from directly from the Heroku website? The question is asking how to export a CSV file using Heroku's web interface, not the command line interface.

ctshryock's answer is exactly what I was looking for. The question you are referring to shows a slightly more complicated way since it is not linked directly to Heroku. But thanks anyways! — thewheelz, Mar 22 '13 at 16:52

score 2 · Accepted Answer · answered Mar 22 '13 at 15:31

2

You can export a csv of a single table using dataclips: https://dataclips.heroku.com

To export the entire database like this you would need to do this one table at a time

answered Mar 22 '13 at 15:31

catsby

11,276
3
37
37

great - works very well! – thewheelz Mar 22 '13 at 16:38

Using the Heroku web interface, how do you export a PG database from Heroku into a CSV file?

1 Answers1