Postgres: Difference between revisions
| Line 6: | Line 6: | ||
\dt // show tables | \dt // show tables | ||
<SQL>; | <SQL>; | ||
dropdb -h <HOSTNAME> -U <User> <DB> | |||
Revision as of 07:02, 17 September 2021
Operation
psql -h <HOSTNAME> -U <USER> [<DB>] psql <DB> <USER> \l // show databases \c <DB> // connect to DB \dt // show tables <SQL>; dropdb -h <HOSTNAME> -U <User> <DB>