Postgres: Difference between revisions
| Line 2: | Line 2: | ||
psql -h <HOSTNAME> -U <USER> [<DB>] | psql -h <HOSTNAME> -U <USER> [<DB>] | ||
psql <DB> <USER> | psql <DB> <USER> | ||
\l // show databases | |||
\c <DB> // connect to DB | |||
\dt // show tables | |||
<SQL>; | |||
Revision as of 13:14, 15 September 2021
Operation
psql -h <HOSTNAME> -U <USER> [<DB>] psql <DB> <USER> \l // show databases \c <DB> // connect to DB \dt // show tables <SQL>;