Skip to content

Instantly share code, notes, and snippets.

@jkeam

jkeam/heroku_postgres_table_dump.sh

Created February 25, 2019 15:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jkeam/f9719aec8e2c39e46ea8f03070519a20 to your computer and use it in GitHub Desktop.
Save jkeam/f9719aec8e2c39e46ea8f03070519a20 to your computer and use it in GitHub Desktop.
Download ZIP
Heroku Table Dump
Raw
heroku_postgres_table_dump.sh
# get database info
heroku config:get DATABASE_URL -a app_name
# dump command
pg_dump --column-inserts --no-acl --no-owner -h host_name -U postgres_user -t table_name --data-only db_name > output_filename.dump
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment