• \l - list databases
  • \c - connect to db
  • \dn - list schemas
  • \dt - list tables
  • \dtS - list tables + system tables
  • \q - quit
  • postgres=# SHOW search_path;
  • postgres=# \dt
  • postgres=# SET search_path TO api;
  • postgres=# \dt
  • postgres=# SET search_path TO “$user”,public;