Difference between revisions of "Pg database"

Revision as of 14:20, 27 September 2024

SELECT datname FROM pg_database;

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

Revision as of 14:20, 27 September 2024 (edit) Welcome (talk \| contribs) (→‎Related terms) ← Older edit		Revision as of 14:20, 27 September 2024 (edit) (undo) Welcome (talk \| contribs) Newer edit →
Line 2:		Line 2:
	* <code>pg_database</code>		* <code>pg_database</code>

−	SELECT datname FROM ~~pg database~~;	+	SELECT datname FROM pg_database;