Postgres

From Wiki RB4
Revision as of 13:14, 15 September 2021 by UweHeuer (talk | contribs) (→‎Operation)

Operation

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