Easy way to view postgresql dump files?

at. picture at. · Apr 25, 2013 · Viewed 50.1k times · Source

I have a ton of postgresql dump files I need to peruse through for data. Do I have to install Postgresql and "recover" each one of them into new databases one by one? Or I'm hoping there's a postgresql client that can simply open them up and I can peek at the data, maybe even run a simple SQL query?

The dump files are all from a Postgresql v9.1.9 server.

Or maybe there's a tool that can easily make a database "connection" to the dump files?

UPDATE: These are not text files. They are binary. They come from Heroku's backup mechanism, this is what Heroku says about how they create their backups:

PG Backups uses the native pg_dump PostgreSQL tool to create its backup files, making it trivial to export to other PostgreSQL installations.

Answer

jcuenod picture jcuenod · Mar 10, 2015

This was what I was looking for:

pg_restore db.bin > db.sql

Thanks @andrewtweber