Postgres: Difference between revisions

From Wiki RB4
Line 4: Line 4:
  \l // show databases
  \l // show databases
  \c <DB> // connect to DB
  \c <DB> // connect to DB
\dt // show tables

Revision as of 13:08, 15 September 2021

Operation

psql -h <HOSTNAME> -U <USER> [<DB>]
psql <DB> <USER>
\l // show databases
\c <DB> // connect to DB
\dt // show tables