{"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","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"],"slug":"alter-rule","source_rev":"a709ab85","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":"a709ab85","Facts":{"anchor":"SQL-ALTERRULE","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"},"ManualEvidence":{},"MeasuredEvidence":{}},"Text":{"Collection":"sql","Key":"alter-rule","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"ALTER RULE","Summary":"修改一条重写规则的定义","BodyHTML":"\u003cpre\u003eALTER RULE name ON table_name RENAME TO new_name\u003c/pre\u003e\u003csection\u003e\u003ch2\u003e描述\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eALTER RULE\u003c/code\u003e更改一条现有规则的属性。目前唯一可用的操作是更改规则的名称。\u003c/p\u003e\u003cp\u003e要使用\u003ccode\u003eALTER RULE\u003c/code\u003e，你必须是该规则适用的表或视图的拥有者。\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e参数\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\u003e要修改的现有规则的名称。\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\u003e该规则适用的表或视图名称（可以是模式限定的）。\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\u003e该规则的新名称。\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e示例\u003c/h2\u003e\u003cp\u003e要重命名一条现有规则：\u003c/p\u003e\u003cpre\u003eALTER 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\u003ccode\u003eALTER RULE\u003c/code\u003e是\u003cspan\u003ePostgreSQL\u003c/span\u003e 的一种语言扩展，整个查询重写系统也是如此。\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e另见\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":"1b5ca64c","ContentHash":"f817d23d7e86a814afc4027d1c2c22fd966709da15bb186112a55074c43b5b9a","Payload":{"purpose_zh":"修改一条重写规则的定义","sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER RULE\u003c/code\u003e更改一条现有规则的属性。目前唯一可用的操作是更改规则的名称。\u003c/p\u003e\u003cp\u003e要使用\u003ccode class=\"command\"\u003eALTER RULE\u003c/code\u003e，你必须是该规则适用的表或视图的拥有者。\u003c/p\u003e","key":"description","title":"描述"},{"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\u003e要修改的现有规则的名称。\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\u003e该规则适用的表或视图名称（可以是模式限定的）。\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\u003e该规则的新名称。\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"参数"},{"html":"\u003cp\u003e要重命名一条现有规则：\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eALTER RULE notify_all ON emp RENAME TO notify_me;\n\u003c/pre\u003e","key":"examples","title":"示例"},{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER RULE\u003c/code\u003e是\u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e 的一种语言扩展，整个查询重写系统也是如此。\u003c/p\u003e","key":"compatibility","title":"兼容性"},{"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":"另见"}],"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":"zh-Hans","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}