Difference between revisions of "Show databases"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
Tags: Mobile web edit, Mobile edit
Line 6: Line 6:
 
  postgres
 
  postgres
 
  (1 row)
 
  (1 row)
 +
 +
SELECT datname FROM pg_database WHERE datistemplate = false;
 +
datname
 +
----------
 +
postgres
 +
your_database_name
 +
(2 rows)
  
  

Revision as of 07:46, 15 April 2020

PostgreSQL:

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


Related terms

See also

Advertising: