Postgres: Difference between revisions

From Wiki RB4
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>