Redshift Observatory

System Table Tracker

System view pg_catalog.pg_rules version 1.0.71912 / 2024-08-02

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