Difference between revisions of "PostgreSQL meta-commands"

From wikieduonline
Jump to navigation Jump to search
 
(12 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]]
+
  [[\du]]          [[List users]]
 
  [[\du+]]
 
  [[\du+]]
 
  [[\dg]]
 
  [[\dg]]
 
  [[\ddp]]
 
  [[\ddp]]
  [[\dp]]
+
  [[\dp]]           Lists tables, views and [[sequences]] with their associated access privileges
 
  [[\dp]] *.*
 
  [[\dp]] *.*
 
  [[\list]]
 
  [[\list]]
 
  [[\dn]]          Lists [[schemas]] ([[namespaces]])
 
  [[\dn]]          Lists [[schemas]] ([[namespaces]])
 +
[[\dn+]]
 
  [[\dt]]
 
  [[\dt]]
 
  [[\c]]
 
  [[\c]]
 
  [[\l]]
 
  [[\l]]
 +
[[\di]]
  
  \dE[S+] [ pattern ] [[foreign table]]
+
  [[\dE]][S+] [ pattern ] [[foreign table]]
  \di[S+] [ pattern ] [[Index (PostgreSQL)|index]]
+
  [[\di]][S+] [ pattern ] [[Index (PostgreSQL)|index]]
  \dm[S+] [ pattern ] [[materialized view]]
+
  [[\dm]][S+] [ pattern ] [[materialized view]]
  \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]]
  
 +
[[\df]][S+]
 +
 +
[[\conninfo]]
  
 
== Related ==
 
== Related ==
* [[Tables]], [[views]], [[Schemas]]
+
* [[Index]], [[Table]], [[foreign table]], [[Schema]], [[Sequence]], [[Views]], [[materialized view]]
  
 
== See also ==
 
== See also ==

Latest revision as of 17:48, 8 January 2024

Advertising: