Short Notes on PSQL
Revision as of 17:46, 8 April 2020 by Admin
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