Redshift Observatory

System Table Tracker

System view pg_catalog.pg_rules version 1.0.50300 / 2023-05-09

schema	name	column	data type
pg_catalog	pg_rules	definition	text
pg_catalog	pg_rules	rulename	name
pg_catalog	pg_rules	schemaname	name
pg_catalog	pg_rules	tablename	name

View Text

SELECT n.nspname AS schemaname,
       c.relname AS tablename,
       r.rulename,
       pg_get_ruledef(r.oid) AS definition
FROM pg_rewrite AS r
     INNER JOIN pg_class AS c ON c.oid = r.ev_class
     LEFT JOIN pg_namespace AS n ON n.oid = c.relnamespace
WHERE r.rulename <> CAST('_RETURN' AS name)

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