Difference between revisions of "PostgreSQL meta-commands"

From wikieduonline
Jump to navigation Jump to search
Line 23: Line 23:
  
 
== Related ==
 
== Related ==
* [[Tables]], [[views]], [[Schemas]], [[sequences]]
+
* [[Index]], [[Table]], [[Schema]], [[Sequence]], [[Views]]
  
 
== See also ==
 
== See also ==

Revision as of 19:40, 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: