Importing data from Heroku PostgeSQL application

import.sh

heroku pg:backups capture

# replace BACKUP_NUM with backup number from above
heroku pg:backups public-url BACKUP_NUM

# replace URL with step from above
curl -o latest.dump URL

# replace LOCAL_DB_NAME with local database table
# replace DB_USERNAME with db user
# replace DB_CONNECTION with db connection
pg_restore --verbose --clean --no-acl --no-owner -h DB_CONNECTION -U DB_USERNAME -d LOCAL_DB_NAME latest.dump