Difference between revisions of "Pg database"

From wikieduonline
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
* <code>pg_database</code>
 
* <code>pg_database</code>
  
  SELECT datname FROM pg_database WHERE datistemplate = false;
+
  [[SELECT datname FROM pg_database;]]
 +
 
 +
 
 +
SELECT [[datname]] FROM pg_database WHERE datistemplate = false;
 
   datname
 
   datname
 
  ----------
 
  ----------
Line 11: Line 14:
 
== Related terms ==
 
== Related terms ==
 
* [[Autovacuum]]
 
* [[Autovacuum]]
 +
* <code>[[\l]]</code>
  
 
== See also ==
 
== See also ==

Latest revision as of 14:20, 27 September 2024

  • pg_database
SELECT datname FROM pg_database;


SELECT datname FROM pg_database WHERE datistemplate = false;
 datname
----------
 postgres
(1 row)


Related terms[edit]

See also[edit]

Advertising: