Skip to content

Instantly share code, notes, and snippets.

@yannvery

yannvery/postgre_cheatsheet.md

Last active April 19, 2016 08:57
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 yannvery/63d0ec3231ce2163f66404281e957991 to your computer and use it in GitHub Desktop.
Save yannvery/63d0ec3231ce2163f66404281e957991 to your computer and use it in GitHub Desktop.
Download ZIP
postgre cheatsheet
Raw
postgre_cheatsheet.md

Export database

pg_dump database_name > database_name.dump

Export Structure

pg_dump -s database_name > database_name.dump

Restore/Import Database with pg_dump

pg_restore --verbose --clean --no-acl --no-owner -h localhost -d database_name database_file.dump

Restore/Import database with psql

psql -U root -d database_name -1 -f database_file.dump

List databases

psql
=# \l
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment