Difference between revisions of "PostgreSQL meta-commands"

From wikieduonline
Jump to navigation Jump to search
Line 5: Line 5:
 
  [[\dg]]
 
  [[\dg]]
 
  [[\ddp]]
 
  [[\ddp]]
  [[\dp]]
+
  [[\dp]]           Lists tables, views and [[sequences]] with their associated access privileges
 
  [[\dp]] *.*
 
  [[\dp]] *.*
 
  [[\list]]
 
  [[\list]]

Revision as of 10:20, 28 April 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
\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: