title: How to restore a single table from a .sql postgresql backup?
body: <p>A table's rows were mistakenly deleted from the database. We have a db backup which results in a sql file that can restored like so:</p>
  
  <pre><code>psql -h localhost -d proddump -f /Users/U/Desktop/prod_db_backup/PostgreSQL/site_prod.sql
  </code></pre>
  
  <p>This ends up doing a full restore locally. But what we need is to restore a single table's rows to production. Any tips on how to make this work with PostgreSQL 9.1?</p>
  
  <p>Thanks</p>