Redshift Research Project

System Table Tracker

System view pg_catalog.pg_class_info version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog pg_class_info relacl aclitem[]
pg_catalog pg_class_info relam oid
pg_catalog pg_class_info relchecks int2
pg_catalog pg_class_info relcreationtime timestamp
pg_catalog pg_class_info reldiststyle int2
pg_catalog pg_class_info releffectivediststyle int2
pg_catalog pg_class_info relexternid oid
pg_catalog pg_class_info relfilenode oid
pg_catalog pg_class_info relfkeys int2
pg_catalog pg_class_info relhasindex bool
pg_catalog pg_class_info relhasoids bool
pg_catalog pg_class_info relhaspkey bool
pg_catalog pg_class_info relhasrules bool
pg_catalog pg_class_info relhassubclass bool
pg_catalog pg_class_info relispinned bool
pg_catalog pg_class_info relisreplicated bool
pg_catalog pg_class_info relisshared bool
pg_catalog pg_class_info relkind char(1)
pg_catalog pg_class_info relname name
pg_catalog pg_class_info relnamespace oid
pg_catalog pg_class_info relnatts int2
pg_catalog pg_class_info reloid oid
pg_catalog pg_class_info relowner int4
pg_catalog pg_class_info relpages int4
pg_catalog pg_class_info relprojbaseid oid
pg_catalog pg_class_info relrefs int2
pg_catalog pg_class_info reltablespace oid
pg_catalog pg_class_info reltoastidxid oid
pg_catalog pg_class_info reltoastrelid oid
pg_catalog pg_class_info reltriggers int2
pg_catalog pg_class_info reltuples float4
pg_catalog pg_class_info reltype oid
pg_catalog pg_class_info relukeys int2

View Text

SELECT pgc.oid AS reloid,
       pgc.relname,
       pgc.relnamespace,
       pgc.reltype,
       pgc.relowner,
       pgc.relam,
       pgc.relfilenode,
       pgc.reltablespace,
       pgc.relpages,
       pgc.reltuples,
       pgc.reltoastrelid,
       pgc.reltoastidxid,
       pgc.relhasindex,
       pgc.relisshared,
       pgc.relkind,
       pgc.relnatts,
       pgc.relexternid,
       pgc.relisreplicated,
       pgc.relispinned,
       pgc.reldiststyle,
       pgc.relprojbaseid,
       pgc.relchecks,
       pgc.reltriggers,
       pgc.relukeys,
       pgc.relfkeys,
       pgc.relrefs,
       pgc.relhasoids,
       pgc.relhaspkey,
       pgc.relhasrules,
       pgc.relhassubclass,
       pgc.relacl,
       COALESCE(CAST(pgce0.value AS smallint),
                pgc.reldiststyle) AS releffectivediststyle,
       date_add(CAST('microsecond' AS text),
                CAST(pgce1.value AS bigint),
                CAST('2000-01-01 00:00:00' AS timestamp)) AS relcreationtime
FROM pg_class AS pgc
     LEFT JOIN pg_class_extended AS pgce0 ON pgc.oid = pgce0.reloid
                                         AND pgce0.colnum = 0
     LEFT JOIN pg_class_extended AS pgce1 ON pgc.oid = pgce1.reloid
                                         AND pgce1.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