Difference between revisions of "PostgreSQL meta-commands"

From wikieduonline
Jump to navigation Jump to search
Line 21: Line 21:
 
  [[\dt]][S+] [ pattern ] [[table]]
 
  [[\dt]][S+] [ pattern ] [[table]]
 
  [[\dv]][S+] [ pattern ] [[Views|view]]
 
  [[\dv]][S+] [ pattern ] [[Views|view]]
 +
 +
[[\df]][S+]
  
 
== Related ==
 
== Related ==

Revision as of 14:11, 28 September 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
\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+]

Related

See also

Advertising: