postgresql
Table of Contents
PostgreSQL
Cheatsheet
# install package apt install postgresql # connect psql -h <hostname> -p 5432 -U <username> -d <dbname> -W \l # list databases \c <dbname> # connect to a database \dt # list tables # dump pg_dump -h <hostname> -p 5432 -U postgre -W -F t <dbname> > ./<dumpname>.tar # restore pg_restore -d <dbname> ./<dumpname>.tar -c -U <username> -h <hostname> -p 5432
Links
postgresql.txt · Last modified: 2020/05/02 09:34 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
