Difference between revisions of "Pg database"

From wikieduonline
Jump to navigation Jump to search
(Created page with " == See also == * {{pg}} Category:PostgreSQL")
 
 
(14 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
{{lowercase}}
 +
* <code>pg_database</code>
  
 +
[[SELECT datname FROM pg_database;]]
  
  
 +
SELECT [[datname]] FROM pg_database WHERE datistemplate = false;
 +
  datname
 +
----------
 +
  postgres
 +
(1 row)
 +
 +
 +
== Related terms ==
 +
* [[Autovacuum]]
 +
* <code>[[\l]]</code>
  
 
== See also ==
 
== See also ==
 
* {{pg}}
 
* {{pg}}
 +
* {{VACUUM}}
  
 
[[Category:PostgreSQL]]
 
[[Category:PostgreSQL]]

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: