Redshift Observatory

System Table Tracker

System view pg_catalog.pg_tables version 1.0.41533 / 2022-09-18

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 Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers