Difference between revisions of "PostgreSQL meta-commands"
Jump to navigation
Jump to search
| (12 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]] |
[[\du+]] | [[\du+]] | ||
[[\dg]] | [[\dg]] | ||
[[\ddp]] | [[\ddp]] | ||
| − | [[\dp]] | + | [[\dp]] Lists tables, views and [[sequences]] with their associated access privileges |
[[\dp]] *.* | [[\dp]] *.* | ||
[[\list]] | [[\list]] | ||
[[\dn]] Lists [[schemas]] ([[namespaces]]) | [[\dn]] Lists [[schemas]] ([[namespaces]]) | ||
| + | [[\dn+]] | ||
[[\dt]] | [[\dt]] | ||
[[\c]] | [[\c]] | ||
[[\l]] | [[\l]] | ||
| + | [[\di]] | ||
| − | \dE[S+] [ pattern ] [[foreign table]] | + | [[\dE]][S+] [ pattern ] [[foreign table]] |
| − | \di[S+] [ pattern ] [[Index (PostgreSQL)|index]] | + | [[\di]][S+] [ pattern ] [[Index (PostgreSQL)|index]] |
| − | \dm[S+] [ pattern ] [[materialized view]] | + | [[\dm]][S+] [ pattern ] [[materialized view]] |
| − | \ds[S+] [ pattern ] [[sequence]] | + | [[\ds]][S+] [ pattern ] [[sequence]] |
| − | \dt[S+] [ pattern ] [[table]] | + | [[\dt]][S+] [ pattern ] [[table]] |
| − | \dv[S+] [ pattern ] [[view]] | + | [[\dv]][S+] [ pattern ] [[Views|view]] |
| + | [[\df]][S+] | ||
| + | |||
| + | [[\conninfo]] | ||
== Related == | == 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:
