wiki.lkaplan.cz

• \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;