Difference between revisions of "PostgreSQL meta-commands"
Jump to navigation
Jump to search
| (21 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 | + | [[\du]] [[List users]] |
| − | \dg | + | [[\du+]] |
| − | \ddp | + | [[\dg]] |
| − | \dp | + | [[\ddp]] |
| − | \list | + | [[\dp]] Lists tables, views and [[sequences]] with their associated access privileges |
| − | \dn | + | [[\dp]] *.* |
| − | \dt | + | [[\list]] |
| − | \c | + | [[\dn]] Lists [[schemas]] ([[namespaces]]) |
| − | \l | + | [[\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:
