{"Entry":{"collection":"catalog","key":"pg_rules","name":"pg_rules","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"rule definition (a reconstructed creation command)","name":"definition","to":"Rule definition (a reconstructed creation command)"},{"from":"name of rule","name":"rulename","to":"Name of rule"},{"from":"name of schema containing table","name":"schemaname","to":"Name of schema containing table"},{"from":"name of table the rule is for","name":"tablename","to":"Name of table the rule is for"}],"from":"8.1","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.2","types":[],"unlisted":[]}],"column_count":4,"content_hash":"ea15fecd00b9a98ea045b2cd1c1500d628216cd37ca39b99137036dfbab867d7","derived_content_hash":"8744dd0d6c2f01e1d4eeab3e485e488c75476970ac1ce32a100ef125fe0fdfa9","first_version":"7.4","imported_at":"2026-09-30T00:40:55.782464+08:00","kind":"view","last_version":"20","name":"pg_rules","position":69,"present_in":["7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"catalog-bilingual-repair:9a5cb2e01372c5e7d64521850fae4a31ddf7699f93671718ccb4c7184404b3ce","summary":"The view pg_rules provides access to useful information about query rewrite rules.","summary_zh":"视图 pg_rules 提供了有关查询重写规则的有用信息。"}},"Definition":{"Collection":"catalog","Key":"pg_rules","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_rules","SourceRevision":"catalog-bilingual-repair:9a5cb2e01372c5e7d64521850fae4a31ddf7699f93671718ccb4c7184404b3ce","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Name of schema containing table","description_zh":"包含表的模式名称","documented":true,"documented_name":"schemaname","hidden":false,"name":"schemaname","not_null":false,"references":"pg_namespace.nspname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Name of table the rule is for","description_zh":"规则适用的表名","documented":true,"documented_name":"tablename","hidden":false,"name":"tablename","not_null":false,"references":"pg_class.relname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Name of rule","description_zh":"规则名","documented":true,"documented_name":"rulename","hidden":false,"name":"rulename","not_null":false,"references":"pg_rewrite.rulename","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Rule definition (a reconstructed creation command)","description_zh":"规则定义（重建的创建命令）","documented":true,"documented_name":"definition","hidden":false,"name":"definition","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"}],"description":"The view pg_rules provides access to useful information about query rewrite rules.","description_zh":"视图 pg_rules 提供了有关查询重写规则的有用信息。","description_zh_html":"\u003cp\u003e视图 pg_rules 提供了有关查询重写规则的有用信息。\u003c/p\u003e","doc":{"anchor":"id-1.10.5.26.4","file":"view-pg-rules.html","lang":"en","sha256":"e20fe2d89a2bd25c7ac727947a63aebbe36103292a7a22ce29f6e0807d1ba054","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["schemaname","tablename","rulename","definition"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-rules.html","sha256":"d27fc54875a2bb141fefca0322b69ae076c40e3e5ccd83994cd8e07b78750d7e","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:3997ae0c43311c97bbb08c9907b519c4797ed4ef4ac54147c1c93318ac81d480","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.26.4","file":"view-pg-rules.html","lang":"en","sha256":"e20fe2d89a2bd25c7ac727947a63aebbe36103292a7a22ce29f6e0807d1ba054","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"view-pg-rules.html","sha256":"d27fc54875a2bb141fefca0322b69ae076c40e3e5ccd83994cd8e07b78750d7e","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:3997ae0c43311c97bbb08c9907b519c4797ed4ef4ac54147c1c93318ac81d480","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["schemaname","tablename","rulename","definition"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_rules","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_rules","Summary":"The view pg_rules provides access to useful information about query rewrite rules.","BodyHTML":"\u003cp\u003eThe view pg_rules provides access to useful information about query rewrite rules.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:9a5cb2e01372c5e7d64521850fae4a31ddf7699f93671718ccb4c7184404b3ce","ContentHash":"119c24618ab163ae0494c7eb571d80342bebccf2d6b5d9cb2d8c3c36104c2708","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Name of schema containing table","description_zh":"包含表的模式名称","documented":true,"documented_name":"schemaname","hidden":false,"name":"schemaname","not_null":false,"references":"pg_namespace.nspname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Name of table the rule is for","description_zh":"规则适用的表名","documented":true,"documented_name":"tablename","hidden":false,"name":"tablename","not_null":false,"references":"pg_class.relname","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Name of rule","description_zh":"规则名","documented":true,"documented_name":"rulename","hidden":false,"name":"rulename","not_null":false,"references":"pg_rewrite.rulename","type":"name","type_modifier":-1,"type_oid":19,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Rule definition (a reconstructed creation command)","description_zh":"规则定义（重建的创建命令）","documented":true,"documented_name":"definition","hidden":false,"name":"definition","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"}],"description":"The view pg_rules provides access to useful information about query rewrite rules."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}