Difference between revisions of "Short Notes on PSQL"
From PaskvilWiki
(Created page with "PSQL aka Postgres aka PostgreSQL... I prefer psql. == Dump and Restore == <pre>dump: $ pg_dump -h host -p 5432 -U user -F c -b -v -f /tmp/db_name.backup db_name restore: $ p...") |
(No difference)
|
Revision as of 16:46, 8 April 2020
PSQL aka Postgres aka PostgreSQL... I prefer psql.
Dump and Restore
dump: $ pg_dump -h host -p 5432 -U user -F c -b -v -f /tmp/db_name.backup db_name restore: $ pg_restore -h host -p 5432 -U user -d db_name -v /tmp/db_name.backup
