title: Easy way to view postgresql dump files?
body: <p>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?</p>
  
  <p>The dump files are all from a Postgresql v9.1.9 server.</p>
  
  <p>Or maybe there's a tool that can easily make a database "connection" to the dump files?</p>
  
  <p><strong><em>UPDATE</em></strong>: These are <strong>not text files</strong>. They are <strong>binary</strong>. They come from Heroku's backup mechanism, this is <a href="https://devcenter.heroku.com/articles/heroku-postgres-import-export" rel="noreferrer">what Heroku says about how they create their backups</a>:</p>
  
  <blockquote>
    <p>PG Backups uses the native pg_dump PostgreSQL tool to create its
    backup files, making it trivial to export to other PostgreSQL
    installations.</p>
  </blockquote>