Difference between revisions of "PostgreSQL meta-commands"
Jump to navigation
Jump to search
Line 5: | Line 5: | ||
[[\dg]] | [[\dg]] | ||
[[\ddp]] | [[\ddp]] | ||
− | [[\dp]] | + | [[\dp]] Lists tables, views and [[sequences]] with their associated access privileges |
[[\dp]] *.* | [[\dp]] *.* | ||
[[\list]] | [[\list]] |
Revision as of 10:20, 28 April 2022
https://www.postgresql.org/docs/current/app-psql.html
\du List users \du+ \dg \ddp \dp Lists tables, views and sequences with their associated access privileges \dp *.* \list \dn Lists schemas (namespaces) \dn+ \dt \c \l
\dE[S+] [ pattern ] foreign table \di[S+] [ pattern ] index \dm[S+] [ pattern ] materialized view \ds[S+] [ pattern ] sequence \dt[S+] [ pattern ] table \dv[S+] [ pattern ] view
Related
See also
Advertising: