Redshift Observatory

System Table Tracker

System view pg_catalog.pg_database_info version 1.0.52931 / 2023-07-07

schema	name	column	data type
pg_catalog	pg_database_info	datacl	aclitem[]
pg_catalog	pg_database_info	datallowconn	bool
pg_catalog	pg_database_info	datconfig	text[]
pg_catalog	pg_database_info	datconnlimit	text
pg_catalog	pg_database_info	datdba	int4
pg_catalog	pg_database_info	datfrozenxid	xid
pg_catalog	pg_database_info	datid	oid
pg_catalog	pg_database_info	datistemplate	bool
pg_catalog	pg_database_info	datlastsysoid	oid
pg_catalog	pg_database_info	datname	name
pg_catalog	pg_database_info	dattablespace	oid
pg_catalog	pg_database_info	datvacuumxid	xid
pg_catalog	pg_database_info	encoding	int4

View Text

SELECT pg_database.oid AS datid,
       pg_database.datname,
       pg_database.datdba,
       pg_database.encoding,
       pg_database.datistemplate,
       pg_database.datallowconn,
       pg_database.datlastsysoid,
       pg_database.datvacuumxid,
       pg_database.datfrozenxid,
       pg_database.dattablespace,
       pg_database.datconfig,
       pg_database.datacl,
       CASE
         WHEN pde_col1.value = CAST(- CAST(1 AS smallint) AS text)
           THEN CAST('UNLIMITED' AS text)
         ELSE pde_col1.value
       END AS datconnlimit
FROM pg_database
     LEFT JOIN pg_database_extended AS pde_col1 ON pg_database.oid = pde_col1.dbid
                                               AND pde_col1.colnum = 1

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers