Difference between revisions of "PostgreSQL meta-commands"
Jump to navigation
Jump to search
(22 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
https://www.postgresql.org/docs/current/app-psql.html | 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]] | ||
+ | [[\di]] | ||
+ | |||
+ | [[\dE]][S+] [ pattern ] [[foreign table]] | ||
+ | [[\di]][S+] [ pattern ] [[Index (PostgreSQL)|index]] | ||
+ | [[\dm]][S+] [ pattern ] [[materialized view]] | ||
+ | [[\ds]][S+] [ pattern ] [[sequence]] | ||
+ | [[\dt]][S+] [ pattern ] [[table]] | ||
+ | [[\dv]][S+] [ pattern ] [[Views|view]] | ||
+ | |||
+ | [[\df]][S+] | ||
+ | |||
+ | [[\conninfo]] | ||
+ | |||
+ | == Related == | ||
+ | * [[Index]], [[Table]], [[foreign table]], [[Schema]], [[Sequence]], [[Views]], [[materialized view]] | ||
== See also == | == See also == |
Latest revision as of 17:48, 8 January 2024
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 \di
\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
\df[S+]
\conninfo
Related[edit]
See also[edit]
Advertising: