How do I restore a partial backup or single table using Postgres?
You'd like to restore part of a database dump instead of restoring all the tables.
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.