{"Entry":{"collection":"sql","key":"alter-rule","name":"ALTER RULE","aliases":["alterrule"],"metadata":{"aliases":["alterrule"],"changed_in":[],"changes":[{"from":"9.2","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":[],"removed":[]},"status":"added","synopsis":null,"to":"9.3"}],"content_hash":"ade8a041c3cba37fbe1820c482d3ab6031f01b9290f865d7aaf4f0ce29024695","derived_content_hash":"0dfd59a245f0e39ea46b74eb0abcd30c03249ae6fa60ddde74ee2dc89d4e369f","editorial":{},"first_version":"9.3","group":"trigger","imported_at":"2026-09-30T17:43:38.397918+08:00","last_version":"20","name":"ALTER RULE","object":"RULE","position":6005,"present_in":["9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"purpose":"change the definition of a rule","purpose_zh":"","related":["create-rule","drop-rule"],"repair_provenance":{"original_source_revision":"a709ab85","receipt_sha256":"fccbc75d40888ab85105dfc2e0d986c9de6c9b281f505338205f650d384952e9","repair":"wiki-repair-20261023"},"slug":"alter-rule","source_rev":"wiki-repair-20261023:5308f09328bf0fed18b104dcc1921e37e4b8210b70bed8cf39426e7cf4fdb5a1","synopsis":"ALTER RULE name ON table_name RENAME TO new_name","verb":"ALTER"}},"Definition":{"Collection":"sql","Key":"alter-rule","SourceDatabase":"center","Version":"18","SourceTable":"sqlcmd","SourceKey":"alter-rule","SourceRevision":"wiki-repair-20261023:5308f09328bf0fed18b104dcc1921e37e4b8210b70bed8cf39426e7cf4fdb5a1","Facts":{"anchor":"SQL-ALTERRULE","description_zh":"修改一条重写规则的定义","description_zh_html":"\u003cpre\u003eALTER RULE name ON table_name RENAME TO new_name\u003c/pre\u003e\u003csection\u003e\u003ch2\u003e描述\u003c/h2\u003e\u003cp\u003e\n\u003ccode class=\"command\"\u003eALTER RULE\u003c/code\u003e 更改一条现有规则的属性。目前唯一可用的操作是更改规则的名称。\n  \u003c/p\u003e\u003cp\u003e\n   要使用 \u003ccode class=\"command\"\u003eALTER RULE\u003c/code\u003e，你必须是该规则适用的表或视图的拥有者。\n  \u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e参数\u003c/h2\u003e\u003cdiv class=\"variablelist\"\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"ZH18-AUTO-ALTER_RULE-VARLISTENTRY-1\"\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n      要修改的现有规则的名称。\n     \u003c/p\u003e\u003c/dd\u003e\u003cdt id=\"ZH18-AUTO-ALTER_RULE-VARLISTENTRY-2\"\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003etable_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n      该规则适用的表或视图名称（可以是模式限定的）。\n     \u003c/p\u003e\u003c/dd\u003e\u003cdt id=\"ZH18-AUTO-ALTER_RULE-VARLISTENTRY-3\"\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n      该规则的新名称。\n     \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e示例\u003c/h2\u003e\u003cp\u003e\n   要重命名一条现有规则：\n\u003c/p\u003e\u003cpre class=\"programlisting\"\u003e\nALTER RULE notify_all ON emp RENAME TO notify_me;\n\u003c/pre\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e兼容性\u003c/h2\u003e\u003cp\u003e\n\u003ccode class=\"command\"\u003eALTER RULE\u003c/code\u003e 是 \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e\n   的一种语言扩展，整个查询重写系统也是如此。\n  \u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e另见\u003c/h2\u003e\u003cspan class=\"simplelist\"\u003e\u003ca class=\"xref\" href=\"/zh/docs/18/sql-createrule.html\" title=\"CREATE RULE\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE RULE\u003c/span\u003e\u003c/a\u003e, \u003ca class=\"xref\" href=\"/zh/docs/18/sql-droprule.html\" title=\"DROP RULE\"\u003e\u003cspan class=\"refentrytitle\"\u003eDROP RULE\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e\u003c/section\u003e","file":"sql-alterrule.html","lang":"en","name":"ALTER RULE","purpose":"change the definition of a rule","purpose_zh":"修改一条重写规则的定义","related":["create-rule","drop-rule"],"sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER RULE\u003c/code\u003e changes properties of an existing rule. Currently, the only available action is to change the rule's name.\u003c/p\u003e\u003cp\u003eTo use \u003ccode class=\"command\"\u003eALTER RULE\u003c/code\u003e, you must own the table or view that the rule applies to.\u003c/p\u003e","key":"description","title":"Description"},{"html":"\u003cdiv class=\"variablelist\"\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name of an existing rule to alter.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003etable_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name (optionally schema-qualified) of the table or view that the rule applies to.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe new name for the rule.\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"Parameters"},{"html":"\u003cp\u003eTo rename an existing rule:\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eALTER RULE notify_all ON emp RENAME TO notify_me;\n\u003c/pre\u003e","key":"examples","title":"Examples"},{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER RULE\u003c/code\u003e is a \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e language extension, as is the entire query rewrite system.\u003c/p\u003e","key":"compatibility","title":"Compatibility"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/create-rule/?v=18\" title=\"CREATE RULE\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE RULE\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/drop-rule/?v=18\" title=\"DROP RULE\"\u003e\u003cspan class=\"refentrytitle\"\u003eDROP RULE\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e","key":"see_also","title":"See Also"}],"sections_same_as":"","slug":"18","synopsis_html":"ALTER RULE \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e ON \u003cem class=\"replaceable\"\u003e\u003ccode\u003etable_name\u003c/code\u003e\u003c/em\u003e RENAME TO \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e","synopsis_text":"ALTER RULE name ON table_name RENAME TO new_name","translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/sql-alterrule.html","sha256":"2137456b95222fc984f5cc881573fda0d20b10b710cc667ef26294ed002d2a52"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-pgdoc"},"ManualEvidence":{},"MeasuredEvidence":{}},"Text":{"Collection":"sql","Key":"alter-rule","SourceDatabase":"center","Version":"18","Locale":"en","Title":"ALTER RULE","Summary":"change the definition of a rule","BodyHTML":"\u003cpre\u003eALTER RULE name ON table_name RENAME TO new_name\u003c/pre\u003e\u003csection\u003e\u003ch2\u003eDescription\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eALTER RULE\u003c/code\u003e changes properties of an existing rule. Currently, the only available action is to change the rule\u0026#39;s name.\u003c/p\u003e\u003cp\u003eTo use \u003ccode\u003eALTER RULE\u003c/code\u003e, you must own the table or view that the rule applies to.\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003eParameters\u003c/h2\u003e\u003cdiv\u003e\u003cdl\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name of an existing rule to alter.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003etable_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name (optionally schema-qualified) of the table or view that the rule applies to.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe new name for the rule.\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003eExamples\u003c/h2\u003e\u003cp\u003eTo rename an existing rule:\u003c/p\u003e\u003cpre\u003eALTER RULE notify_all ON emp RENAME TO notify_me;\n\u003c/pre\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003eCompatibility\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eALTER RULE\u003c/code\u003e is a \u003cspan\u003ePostgreSQL\u003c/span\u003e language extension, as is the entire query rewrite system.\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003eSee Also\u003c/h2\u003e\u003cspan\u003e\u003ca href=\"/wiki/sql/create-rule/?v=18\" title=\"CREATE RULE\" rel=\"nofollow\"\u003e\u003cspan\u003eCREATE RULE\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/drop-rule/?v=18\" title=\"DROP RULE\" rel=\"nofollow\"\u003e\u003cspan\u003eDROP RULE\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e\u003c/section\u003e","SourceRevision":"wiki-repair-20261023:5308f09328bf0fed18b104dcc1921e37e4b8210b70bed8cf39426e7cf4fdb5a1","ContentHash":"5047988a0992005dd5d5217120883127a16c0bca753bff62b5a4aa2520796128","Payload":{"related":["create-rule","drop-rule"],"sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER RULE\u003c/code\u003e changes properties of an existing rule. Currently, the only available action is to change the rule's name.\u003c/p\u003e\u003cp\u003eTo use \u003ccode class=\"command\"\u003eALTER RULE\u003c/code\u003e, you must own the table or view that the rule applies to.\u003c/p\u003e","key":"description","title":"Description"},{"html":"\u003cdiv class=\"variablelist\"\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name of an existing rule to alter.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003etable_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name (optionally schema-qualified) of the table or view that the rule applies to.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe new name for the rule.\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"Parameters"},{"html":"\u003cp\u003eTo rename an existing rule:\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eALTER RULE notify_all ON emp RENAME TO notify_me;\n\u003c/pre\u003e","key":"examples","title":"Examples"},{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER RULE\u003c/code\u003e is a \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e language extension, as is the entire query rewrite system.\u003c/p\u003e","key":"compatibility","title":"Compatibility"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/create-rule/?v=18\" title=\"CREATE RULE\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE RULE\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/drop-rule/?v=18\" title=\"DROP RULE\"\u003e\u003cspan class=\"refentrytitle\"\u003eDROP RULE\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e","key":"see_also","title":"See Also"}],"sections_same_as":"","synopsis_html":"ALTER RULE \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e ON \u003cem class=\"replaceable\"\u003e\u003ccode\u003etable_name\u003c/code\u003e\u003c/em\u003e RENAME TO \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e","synopsis_text":"ALTER RULE name ON table_name RENAME TO new_name"}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}