Difference between revisions of "Pg database"

Latest 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		Latest revision as of 14:20, 27 September 2024 (edit) (undo) Welcome (talk \| contribs)
(One intermediate revision by the same user not shown)
Line 2:		Line 2:
	* <code>pg_database</code>		* <code>pg_database</code>

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