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.
To restore a single table you can use the -t
option in the pg_restore
command. The full pg_restore
documentation is available here.