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

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
– thewheelz, Commented Mar 22, 2013 at 16:52

catsby · Accepted Answer · 2013-03-22 15:31:21Z

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, 2013 at 15:31

catsby

11.4k3 gold badges40 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

thewheelz Over a year ago

great - works very well!

Collectives™ on Stack Overflow

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

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related