Postgres: Difference between revisions
| Line 4: | Line 4: | ||
\l // show databases | \l // show databases | ||
\c <DB> // connect to DB | \c <DB> // connect to DB | ||
\d | \d <TABLE> // show schema of table | ||
\dt // show tables | \dt // show tables | ||
<SQL>; | <SQL>; | ||
Revision as of 12:01, 30 September 2021
Operation
psql -h <HOSTNAME> -U <USER> [<DB>] psql <DB> <USER> \l // show databases \c <DB> // connect to DB \d <TABLE> // show schema of table \dt // show tables <SQL>; CREATE DATABASE <DB>; // !!! case sensitive and semicolon dropdb -h <HOSTNAME> -U <User> <DB> createdb -h <HOSTNAME> -U <User> <DB>