Redshift Research Project

System Table Tracker

System view pg_catalog.pg_tables version 1.0.39009 / 2022-06-08

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