Skip to content

Instantly share code, notes, and snippets.

@atlefren

atlefren/gist:a839c9c890737c12e7d92e5e5effec87

Created April 21, 2020 08:19
Show Gist options
  • Save atlefren/a839c9c890737c12e7d92e5e5effec87 to your computer and use it in GitHub Desktop.
Save atlefren/a839c9c890737c12e7d92e5e5effec87 to your computer and use it in GitHub Desktop.
Download ZIP
pg_dump__pg_restore.sh
Raw
gistfile1.txt
#Dump schema, with no owner, custom format
pg_dump -d DATABASE -n SCHEMA -O -F c -f filename.dmp
#Restore
pg_restore -d DATABASE filename.dmp
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment