This shows you the differences between two versions of the page.
wiki:ostatni:potgres:start [2019/12/16 15:35] root vytvořeno |
wiki:ostatni:potgres:start [2019/12/16 15:35] (current) root |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | \l - list databases | + | * \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 " | + | |