How do I restore a partial backup or single table using Postgres?

Issue

You'd like to restore part of a database dump instead of restoring all the tables.

Resolution

It's possible to establish a connection from a local machine to your Heroku Postgres instance to use pg_restore. This Dev Center article describes how to restore using the pg_restore command in general. This article covers connecting to your database from your local machine.

For a single table you can add a -t to the pg_restore command. The full pg_restore documentation is here.