Difference between revisions of "PostgreSQL meta-commands"
Jump to navigation
Jump to search
(Created page with "https://www.postgresql.org/docs/current/app-psql.html {{psql}}") |
|||
| (23 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]] | ||
| − | {{psql}} | + | [[\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 == | ||
| + | * {{psql}} | ||
| + | |||
| + | [[Category:PostgreSQL]] | ||
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:
