The view pg_rules provides access to useful information about query rewrite rules.

    The pg_rules view excludes the ON SELECT rules of views and materialized views; those can be seen in pg_views and pg_matviews.

    columntypereferencesdescription
    schemanamenamepg_namespace.nspnameName of schema containing table
    tablenamenamepg_class.relnameName of table the rule is for
    rulenamenamepg_rewrite.rulenameName of rule
    definitiontextRule definition (a reconstructed creation command)

    Parent topic: System Catalogs Definitions