Alle Datenbanken

299

Link Reference

Not set

Link Credits

Not set

Link Technical Documentation

Not set

PlCodelang

PL/pgSQL

PlGroup

Datenbank

PlItemTitle

Alle Datenbanken

Code

SELECT
"oid",
datname, -- database name
datdba,
"encoding",
datcollate,
datctype,
datistemplate,
datallowconn,
datconnlimit,
datlastsysoid,
datfrozenxid,
datminmxid,
dattablespace,
datacl
FROM
pg_catalog.pg_database
WHERE datistemplate = FALSE -- do not list template0, template1, ...
;

Result Example

oid	datname	datdba	encoding	datcollate	datctype	datistemplate	datallowconn	datconnlimit	datlastsysoid	datfrozenxid	datminmxid	dattablespace	datacl
12345	postgres	10	6	de_DE.UTF-8	de_DE.UTF-8	false	true	-1	13604	478	1	1663
1	template1	10	6	de_DE.UTF-8	de_DE.UTF-8	true	true	-1	13604	478	1	1663	{=c/postgres,postgres=CTc/postgres}