Redshift Observatory

System Table Tracker

System view pg_catalog.pg_database_info version 1.0.61191 / 2023-12-18

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