Skip to content

Instantly share code, notes, and snippets.

@erikgall

erikgall/pg_restore-one-table-form-dump.sh

Created April 9, 2021 05:34
Show Gist options
  • Save erikgall/89f4a3b6b088148a5f82b575aded9375 to your computer and use it in GitHub Desktop.
Save erikgall/89f4a3b6b088148a5f82b575aded9375 to your computer and use it in GitHub Desktop.
Download ZIP
Restore a single table's data from a PostgreSQL dump file
Raw
pg_restore-one-table-form-dump.sh
pg_restore -t {table_name} -d {database_name} --data-only -e -v path/to/dump/file.dump
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment