Redshift Observatory

System Table Tracker

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

schema name column data type
pg_catalog pg_tables hasindexes bool
pg_catalog pg_tables hasrules bool
pg_catalog pg_tables hastriggers bool
pg_catalog pg_tables schemaname name
pg_catalog pg_tables tablename name
pg_catalog pg_tables tableowner name
pg_catalog pg_tables tablespace name

View Text

SELECT n.nspname AS schemaname,
       c.relname AS tablename,
       pg_get_userbyid(c.relowner) AS tableowner,
       t.spcname AS tablespace,
       c.relhasindex AS hasindexes,
       c.relhasrules AS hasrules,
       c.reltriggers > 0 AS hastriggers
FROM pg_class AS c
     LEFT JOIN pg_namespace AS n ON n.oid = c.relnamespace
     LEFT JOIN pg_tablespace AS t ON t.oid = c.reltablespace
WHERE c.relkind = CAST('r' AS "char")


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