Difference between revisions of "Show databases"

Latest revision as of 17:35, 8 January 2024

\list

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)

rs0:PRIMARY> show databases;
admin       0.031GB
config      0.031GB
local       0.281GB
YOUR_NAME   2.499GB

@@ Line 1: / Line 1: @@
-  SELECT datname FROM pg_database
+{{lc}}
-  WHERE datistemplate = false;
+* [[MariaDB]]: <code>[[show databases;]]</code>
+* [[MongoDB]]: <code>[[show databases;]]</code>
+* [[PostgreSQL]]: <code>[[\list]]</code>
+[[PostgreSQL]]:
+ <code>[[\list]]</code>
+  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)
+* [[MariaDB]]: <code>[[show databases;]]</code>
+* [[MongoDB]]: <code>[[show databases;]]</code>
+ rs0:PRIMARY> show databases;
+ admin       0.031GB
+ config      0.031GB
+ local       0.281GB
+ YOUR_NAME   2.499GB
+== Related terms ==
+* {{TOC operation databases}}
+* [[PostgreSQL]]: <code>[[connect to]] [[MY_DATABASE_NAME]]</code>
+* [[Show (MariaDB)]]
+== See also ==
+* {{SQL}}
+* {{DBs}}
+[[Category:PostgreSQL]]