wiki.lkaplan.cz

This is an old revision of the document!

---

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