53.22. pg_rules #

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

   Table 53.22. pg_rules Columns

   Column Type

   Description

   schemaname name (references pg_namespace.nspname)

   Name of schema containing table

   tablename name (references pg_class.relname)

   Name of table the rule is for

   rulename name (references pg_rewrite.rulename)

   Name of rule

   definition text

   Rule definition (a reconstructed creation command)

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