Postgresql 中文操作指南
54.21. pg_rules #
视图 pg_rules 提供了关于查询重写规则的有用信息。
The view pg_rules provides access to useful information about query rewrite rules.
Table 54.21. pg_rules Columns
Table 54.21. 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) |
pg_rules 视图排除了 ON SELECT 视图和物化视图的规则；这些规则可以在 pg_views 和 pg_matviews 中查看。
The pg_rules view excludes the ON SELECT rules of views and materialized views; those can be seen in pg_views and pg_matviews.