How do I restore a partial backup or single table using Postgres?
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.