Difference between revisions of "PostgreSQL meta-commands"

From wikieduonline
Jump to navigation Jump to search
Line 20: Line 20:
 
  [[\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]]
  
 
== Related ==
 
== Related ==

Revision as of 19:46, 23 June 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

Related

See also

Advertising: