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 13: Line 13:
 
  your_database_name
 
  your_database_name
 
  (2 rows)
 
  (2 rows)
 +
 +
 +
* [[MariaDB]]: <code>[[show databases]]</code>
  
  

Revision as of 12:58, 10 May 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: