{"Entry":{"collection":"sql","key":"alter-materialized-view","name":"ALTER MATERIALIZED VIEW","aliases":["altermaterializedview"],"metadata":{"aliases":["altermaterializedview"],"changed_in":["9.4","9.5","9.6","10","13","14","15","16"],"changes":[{"from":"9.2","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":[],"removed":[]},"status":"added","synopsis":null,"to":"9.3"},{"from":"9.3","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":[],"removed":[]},"status":"changed","synopsis":{"added":["ALTER MATERIALIZED VIEW ALL IN TABLESPACE name [ OWNED BY role_name [, ... ] ]","SET TABLESPACE new_tablespace [ NOWAIT ]"],"removed":["SET TABLESPACE new_tablespace"]},"to":"9.4"},{"from":"9.4","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":[],"removed":[]},"status":"changed","synopsis":{"added":["SET ( storage_parameter [= value] [, ... ] )","OWNER TO { new_owner | CURRENT_USER | SESSION_USER }"],"removed":[]},"to":"9.5"},{"from":"9.5","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description","parameters"],"removed":[]},"status":"changed","synopsis":{"added":["ALTER MATERIALIZED VIEW name","DEPENDS ON EXTENSION extension_name"],"removed":[]},"to":"9.6"},{"from":"9.6","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":[],"removed":[]},"status":"changed","synopsis":{"added":["SET TABLESPACE new_tablespace","SET ( storage_parameter [= value] [, ... ] )"],"removed":[]},"to":"10"},{"from":"11","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["parameters"],"removed":[]},"status":"changed","synopsis":null,"to":"12"},{"from":"12","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description","parameters"],"removed":[]},"status":"changed","synopsis":{"added":["[ NO ] DEPENDS ON EXTENSION extension_name"],"removed":[]},"to":"13"},{"from":"13","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":[],"removed":[]},"status":"changed","synopsis":{"added":["ALTER [ COLUMN ] column_name SET COMPRESSION compression_method","OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }"],"removed":[]},"to":"14"},{"from":"14","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":[],"removed":[]},"status":"changed","synopsis":{"added":["SET ACCESS METHOD new_access_method","SET TABLESPACE new_tablespace"],"removed":[]},"to":"15"},{"from":"15","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description"],"removed":[]},"status":"changed","synopsis":{"added":["ALTER [ COLUMN ] column_name SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }"],"removed":[]},"to":"16"}],"content_hash":"bdc835c9b4f5c1a7060dded5842e149b1decb7f805834de8cc480f6600e8e9ff","editorial":{},"first_version":"9.3","group":"table","imported_at":"2026-09-30T17:43:35.920453+08:00","last_version":"20","name":"ALTER MATERIALIZED VIEW","object":"MATERIALIZED VIEW","position":2,"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 materialized view","purpose_zh":"","related":["create-materialized-view","drop-materialized-view","refresh-materialized-view"],"slug":"alter-materialized-view","source_rev":"a709ab85","synopsis":"ALTER MATERIALIZED VIEW [ IF EXISTS ] name\naction [, ... ]\nALTER MATERIALIZED VIEW name\n[ NO ] DEPENDS ON EXTENSION extension_name\nALTER MATERIALIZED VIEW [ IF EXISTS ] name\nRENAME [ COLUMN ] column_name TO new_column_name\nALTER MATERIALIZED VIEW [ IF EXISTS ] name\nRENAME TO new_name\nALTER MATERIALIZED VIEW [ IF EXISTS ] name\nSET SCHEMA new_schema\nALTER MATERIALIZED VIEW ALL IN TABLESPACE name [ OWNED BY role_name [, ... ] ]\nSET TABLESPACE new_tablespace [ NOWAIT ]\n\nwhere action is one of:\n\nALTER [ COLUMN ] column_name SET STATISTICS integer\nALTER [ COLUMN ] column_name SET ( attribute_option = value [, ... ] )\nALTER [ COLUMN ] column_name RESET ( attribute_option [, ... ] )\nALTER [ COLUMN ] column_name SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }\nALTER [ COLUMN ] column_name SET COMPRESSION compression_method\nCLUSTER ON index_name\nSET WITHOUT CLUSTER\nSET ACCESS METHOD new_access_method\nSET TABLESPACE new_tablespace\nSET ( storage_parameter [= value] [, ... ] )\nRESET ( storage_parameter [, ... ] )\nOWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }","verb":"ALTER"}},"Definition":{"Collection":"sql","Key":"alter-materialized-view","SourceDatabase":"center","Version":"18","SourceTable":"sqlcmd","SourceKey":"alter-materialized-view","SourceRevision":"a709ab85","Facts":{"anchor":"SQL-ALTERMATERIALIZEDVIEW","file":"sql-altermaterializedview.html","lang":"en","name":"ALTER MATERIALIZED VIEW","purpose":"change the definition of a materialized view","purpose_zh":"","related":["create-materialized-view","drop-materialized-view","refresh-materialized-view"],"sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER MATERIALIZED VIEW\u003c/code\u003e changes various auxiliary properties of an existing materialized view.\u003c/p\u003e\u003cp\u003eYou must own the materialized view to use \u003ccode class=\"command\"\u003eALTER MATERIALIZED VIEW\u003c/code\u003e. To change a materialized view's schema, you must also have \u003ccode class=\"literal\"\u003eCREATE\u003c/code\u003e privilege on the new schema. To alter the owner, you must be able to \u003ccode class=\"literal\"\u003eSET ROLE\u003c/code\u003e to the new owning role, and that role must have \u003ccode class=\"literal\"\u003eCREATE\u003c/code\u003e privilege on the materialized view's schema. (These restrictions enforce that altering the owner doesn't do anything you couldn't do by dropping and recreating the materialized view. However, a superuser can alter ownership of any view anyway.)\u003c/p\u003e\u003cp\u003eThe statement subforms and actions available for \u003ccode class=\"command\"\u003eALTER MATERIALIZED VIEW\u003c/code\u003e are a subset of those available for \u003ccode class=\"command\"\u003eALTER TABLE\u003c/code\u003e, and have the same meaning when used for materialized views. See the descriptions for \u003ca href=\"/docs/18/sql-altertable.html\" title=\"ALTER TABLE\"\u003e\u003ccode class=\"command\"\u003eALTER TABLE\u003c/code\u003e\u003c/a\u003e for details.\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 (optionally schema-qualified) of an existing materialized view.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003ecolumn_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eName of an existing column.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003eextension_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name of the extension that the materialized view is to depend on (or no longer dependent on, if \u003ccode class=\"literal\"\u003eNO\u003c/code\u003e is specified). A materialized view that's marked as dependent on an extension is automatically dropped when the extension is dropped.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_column_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eNew name for an existing column.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_owner\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe user name of the new owner of the materialized view.\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 materialized view.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_schema\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe new schema for the materialized view.\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"Parameters"},{"html":"\u003cp\u003eTo rename the materialized view \u003ccode class=\"literal\"\u003efoo\u003c/code\u003e to \u003ccode class=\"literal\"\u003ebar\u003c/code\u003e:\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eALTER MATERIALIZED VIEW foo RENAME TO bar;\n\u003c/pre\u003e","key":"examples","title":"Examples"},{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER MATERIALIZED VIEW\u003c/code\u003e is a \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e extension.\u003c/p\u003e","key":"compatibility","title":"Compatibility"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/create-materialized-view/?v=18\" title=\"CREATE MATERIALIZED VIEW\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE MATERIALIZED VIEW\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/drop-materialized-view/?v=18\" title=\"DROP MATERIALIZED VIEW\"\u003e\u003cspan class=\"refentrytitle\"\u003eDROP MATERIALIZED VIEW\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/refresh-materialized-view/?v=18\" title=\"REFRESH MATERIALIZED VIEW\"\u003e\u003cspan class=\"refentrytitle\"\u003eREFRESH MATERIALIZED VIEW\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e","key":"see_also","title":"See Also"}],"sections_same_as":"","slug":"18","synopsis_html":"ALTER MATERIALIZED VIEW [ IF EXISTS ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    \u003cem class=\"replaceable\"\u003e\u003ccode\u003eaction\u003c/code\u003e\u003c/em\u003e [, ... ]\nALTER MATERIALIZED VIEW \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    [ NO ] DEPENDS ON EXTENSION \u003cem class=\"replaceable\"\u003e\u003ccode\u003eextension_name\u003c/code\u003e\u003c/em\u003e\nALTER MATERIALIZED VIEW [ IF EXISTS ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    RENAME [ COLUMN ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecolumn_name\u003c/code\u003e\u003c/em\u003e TO \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_column_name\u003c/code\u003e\u003c/em\u003e\nALTER MATERIALIZED VIEW [ IF EXISTS ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    RENAME TO \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e\nALTER MATERIALIZED VIEW [ IF EXISTS ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    SET SCHEMA \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_schema\u003c/code\u003e\u003c/em\u003e\nALTER MATERIALIZED VIEW ALL IN TABLESPACE \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e [ OWNED BY \u003cem class=\"replaceable\"\u003e\u003ccode\u003erole_name\u003c/code\u003e\u003c/em\u003e [, ... ] ]\n    SET TABLESPACE \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_tablespace\u003c/code\u003e\u003c/em\u003e [ NOWAIT ]\n\n\u003cspan class=\"phrase\"\u003ewhere \u003cem class=\"replaceable\"\u003e\u003ccode\u003eaction\u003c/code\u003e\u003c/em\u003e is one of:\u003c/span\u003e\n\n    ALTER [ COLUMN ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecolumn_name\u003c/code\u003e\u003c/em\u003e SET STATISTICS \u003cem class=\"replaceable\"\u003e\u003ccode\u003einteger\u003c/code\u003e\u003c/em\u003e\n    ALTER [ COLUMN ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecolumn_name\u003c/code\u003e\u003c/em\u003e SET ( \u003cem class=\"replaceable\"\u003e\u003ccode\u003eattribute_option\u003c/code\u003e\u003c/em\u003e = \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e [, ... ] )\n    ALTER [ COLUMN ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecolumn_name\u003c/code\u003e\u003c/em\u003e RESET ( \u003cem class=\"replaceable\"\u003e\u003ccode\u003eattribute_option\u003c/code\u003e\u003c/em\u003e [, ... ] )\n    ALTER [ COLUMN ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecolumn_name\u003c/code\u003e\u003c/em\u003e SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }\n    ALTER [ COLUMN ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecolumn_name\u003c/code\u003e\u003c/em\u003e SET COMPRESSION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecompression_method\u003c/code\u003e\u003c/em\u003e\n    CLUSTER ON \u003cem class=\"replaceable\"\u003e\u003ccode\u003eindex_name\u003c/code\u003e\u003c/em\u003e\n    SET WITHOUT CLUSTER\n    SET ACCESS METHOD \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_access_method\u003c/code\u003e\u003c/em\u003e\n    SET TABLESPACE \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_tablespace\u003c/code\u003e\u003c/em\u003e\n    SET ( \u003cem class=\"replaceable\"\u003e\u003ccode\u003estorage_parameter\u003c/code\u003e\u003c/em\u003e [= \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e] [, ... ] )\n    RESET ( \u003cem class=\"replaceable\"\u003e\u003ccode\u003estorage_parameter\u003c/code\u003e\u003c/em\u003e [, ... ] )\n    OWNER TO { \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_owner\u003c/code\u003e\u003c/em\u003e | CURRENT_ROLE | CURRENT_USER | SESSION_USER }","synopsis_text":"ALTER MATERIALIZED VIEW [ IF EXISTS ] name\naction [, ... ]\nALTER MATERIALIZED VIEW name\n[ NO ] DEPENDS ON EXTENSION extension_name\nALTER MATERIALIZED VIEW [ IF EXISTS ] name\nRENAME [ COLUMN ] column_name TO new_column_name\nALTER MATERIALIZED VIEW [ IF EXISTS ] name\nRENAME TO new_name\nALTER MATERIALIZED VIEW [ IF EXISTS ] name\nSET SCHEMA new_schema\nALTER MATERIALIZED VIEW ALL IN TABLESPACE name [ OWNED BY role_name [, ... ] ]\nSET TABLESPACE new_tablespace [ NOWAIT ]\n\nwhere action is one of:\n\nALTER [ COLUMN ] column_name SET STATISTICS integer\nALTER [ COLUMN ] column_name SET ( attribute_option = value [, ... ] )\nALTER [ COLUMN ] column_name RESET ( attribute_option [, ... ] )\nALTER [ COLUMN ] column_name SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }\nALTER [ COLUMN ] column_name SET COMPRESSION compression_method\nCLUSTER ON index_name\nSET WITHOUT CLUSTER\nSET ACCESS METHOD new_access_method\nSET TABLESPACE new_tablespace\nSET ( storage_parameter [= value] [, ... ] )\nRESET ( storage_parameter [, ... ] )\nOWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }"},"ManualEvidence":{},"MeasuredEvidence":{}},"Text":{"Collection":"sql","Key":"alter-materialized-view","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"ALTER MATERIALIZED VIEW","Summary":"更改一个物化视图的定义","BodyHTML":"\u003cpre\u003eALTER MATERIALIZED VIEW [ IF EXISTS ] name\naction [, ... ]\nALTER MATERIALIZED VIEW name\n[ NO ] DEPENDS ON EXTENSION extension_name\nALTER MATERIALIZED VIEW [ IF EXISTS ] name\nRENAME [ COLUMN ] column_name TO new_column_name\nALTER MATERIALIZED VIEW [ IF EXISTS ] name\nRENAME TO new_name\nALTER MATERIALIZED VIEW [ IF EXISTS ] name\nSET SCHEMA new_schema\nALTER MATERIALIZED VIEW ALL IN TABLESPACE name [ OWNED BY role_name [, ... ] ]\nSET TABLESPACE new_tablespace [ NOWAIT ]\n\n其中 action 可以是以下之一：\n\nALTER [ COLUMN ] column_name SET STATISTICS integer\nALTER [ COLUMN ] column_name SET ( attribute_option = value [, ... ] )\nALTER [ COLUMN ] column_name RESET ( attribute_option [, ... ] )\nALTER [ COLUMN ] column_name SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }\nALTER [ COLUMN ] column_name SET COMPRESSION compression_method\nCLUSTER ON index_name\nSET WITHOUT CLUSTER\nSET ACCESS METHOD new_access_method\nSET TABLESPACE new_tablespace\nSET ( storage_parameter [= value] [, ... ] )\nRESET ( storage_parameter [, ... ] )\nOWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\u003c/pre\u003e\u003csection\u003e\u003ch2\u003e描述\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eALTER MATERIALIZED VIEW\u003c/code\u003e更改一个现有物化视图的各种辅助属性。\u003c/p\u003e\u003cp\u003e要使用\u003ccode\u003eALTER MATERIALIZED VIEW\u003c/code\u003e，你必须拥有该物化视图。要更改一个物化视图的模式，你还必须具有新模式上的\u003ccode\u003eCREATE\u003c/code\u003e权限。要更改拥有者，你必须能够对新拥有角色执行\u003ccode\u003eSET ROLE\u003c/code\u003e，并且该角色必须具有该物化视图所在模式上的\u003ccode\u003eCREATE\u003c/code\u003e权限。（这些限制确保，更改拥有者不会做到你无法通过删除并重新创建该物化视图来完成的事情。不过，超级用户无论如何都可以更改任何视图的所有权。）\u003c/p\u003e\u003cp\u003e可用于\u003ccode\u003eALTER MATERIALIZED VIEW\u003c/code\u003e的语句形式和动作是 \u003ccode\u003eALTER TABLE\u003c/code\u003e可用形式的一个子集，并且在用于物化视图时具有相同的含义。有关细节请参见\u003ca href=\"/docs/18/sql-altertable.html\" title=\"ALTER TABLE\" rel=\"nofollow\"\u003e\u003ccode\u003eALTER TABLE\u003c/code\u003e\u003c/a\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\u003ecolumn_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\u003eextension_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e该物化视图要依赖的扩展名称（如果指定了\u003ccode\u003eNO\u003c/code\u003e，则表示不再依赖）。删除扩展时，标记为依赖于该扩展的物化视图会被自动删除。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003enew_column_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_owner\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\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003enew_schema\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把物化视图\u003ccode\u003efoo\u003c/code\u003e重命名为 \u003ccode\u003ebar\u003c/code\u003e：\u003c/p\u003e\u003cpre\u003eALTER MATERIALIZED VIEW foo RENAME TO bar;\n\u003c/pre\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e兼容性\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eALTER MATERIALIZED VIEW\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-materialized-view/?v=18\" title=\"CREATE MATERIALIZED VIEW\" rel=\"nofollow\"\u003e\u003cspan\u003eCREATE MATERIALIZED VIEW\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/drop-materialized-view/?v=18\" title=\"DROP MATERIALIZED VIEW\" rel=\"nofollow\"\u003e\u003cspan\u003eDROP MATERIALIZED VIEW\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/refresh-materialized-view/?v=18\" title=\"REFRESH MATERIALIZED VIEW\" rel=\"nofollow\"\u003e\u003cspan\u003eREFRESH MATERIALIZED VIEW\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e\u003c/section\u003e","SourceRevision":"1b5ca64c","ContentHash":"e934691ce960212b5906221e6e90dc6a44a2b8e676e7b95f5ae2b68195c35ee1","Payload":{"purpose_zh":"更改一个物化视图的定义","sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER MATERIALIZED VIEW\u003c/code\u003e更改一个现有物化视图的各种辅助属性。\u003c/p\u003e\u003cp\u003e要使用\u003ccode class=\"command\"\u003eALTER MATERIALIZED VIEW\u003c/code\u003e，你必须拥有该物化视图。要更改一个物化视图的模式，你还必须具有新模式上的\u003ccode class=\"literal\"\u003eCREATE\u003c/code\u003e权限。要更改拥有者，你必须能够对新拥有角色执行\u003ccode class=\"literal\"\u003eSET ROLE\u003c/code\u003e，并且该角色必须具有该物化视图所在模式上的\u003ccode class=\"literal\"\u003eCREATE\u003c/code\u003e权限。（这些限制确保，更改拥有者不会做到你无法通过删除并重新创建该物化视图来完成的事情。不过，超级用户无论如何都可以更改任何视图的所有权。）\u003c/p\u003e\u003cp\u003e可用于\u003ccode class=\"command\"\u003eALTER MATERIALIZED VIEW\u003c/code\u003e的语句形式和动作是 \u003ccode class=\"command\"\u003eALTER TABLE\u003c/code\u003e可用形式的一个子集，并且在用于物化视图时具有相同的含义。有关细节请参见\u003ca href=\"/docs/18/sql-altertable.html\" title=\"ALTER TABLE\"\u003e\u003ccode class=\"command\"\u003eALTER TABLE\u003c/code\u003e\u003c/a\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\u003ecolumn_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\u003eextension_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e该物化视图要依赖的扩展名称（如果指定了\u003ccode class=\"literal\"\u003eNO\u003c/code\u003e，则表示不再依赖）。删除扩展时，标记为依赖于该扩展的物化视图会被自动删除。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_column_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_owner\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\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_schema\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把物化视图\u003ccode class=\"literal\"\u003efoo\u003c/code\u003e重命名为 \u003ccode class=\"literal\"\u003ebar\u003c/code\u003e：\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eALTER MATERIALIZED VIEW foo RENAME TO bar;\n\u003c/pre\u003e","key":"examples","title":"示例"},{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER MATERIALIZED VIEW\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-materialized-view/?v=18\" title=\"CREATE MATERIALIZED VIEW\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE MATERIALIZED VIEW\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/drop-materialized-view/?v=18\" title=\"DROP MATERIALIZED VIEW\"\u003e\u003cspan class=\"refentrytitle\"\u003eDROP MATERIALIZED VIEW\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/refresh-materialized-view/?v=18\" title=\"REFRESH MATERIALIZED VIEW\"\u003e\u003cspan class=\"refentrytitle\"\u003eREFRESH MATERIALIZED VIEW\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e","key":"see_also","title":"另见"}],"sections_same_as":"","synopsis_html":"ALTER MATERIALIZED VIEW [ IF EXISTS ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    \u003cem class=\"replaceable\"\u003e\u003ccode\u003eaction\u003c/code\u003e\u003c/em\u003e [, ... ]\nALTER MATERIALIZED VIEW \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    [ NO ] DEPENDS ON EXTENSION \u003cem class=\"replaceable\"\u003e\u003ccode\u003eextension_name\u003c/code\u003e\u003c/em\u003e\nALTER MATERIALIZED VIEW [ IF EXISTS ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    RENAME [ COLUMN ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecolumn_name\u003c/code\u003e\u003c/em\u003e TO \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_column_name\u003c/code\u003e\u003c/em\u003e\nALTER MATERIALIZED VIEW [ IF EXISTS ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    RENAME TO \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e\nALTER MATERIALIZED VIEW [ IF EXISTS ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    SET SCHEMA \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_schema\u003c/code\u003e\u003c/em\u003e\nALTER MATERIALIZED VIEW ALL IN TABLESPACE \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e [ OWNED BY \u003cem class=\"replaceable\"\u003e\u003ccode\u003erole_name\u003c/code\u003e\u003c/em\u003e [, ... ] ]\n    SET TABLESPACE \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_tablespace\u003c/code\u003e\u003c/em\u003e [ NOWAIT ]\n\n\u003cspan class=\"phrase\"\u003e其中 \u003cem class=\"replaceable\"\u003e\u003ccode\u003eaction\u003c/code\u003e\u003c/em\u003e 可以是以下之一：\u003c/span\u003e\n\n    ALTER [ COLUMN ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecolumn_name\u003c/code\u003e\u003c/em\u003e SET STATISTICS \u003cem class=\"replaceable\"\u003e\u003ccode\u003einteger\u003c/code\u003e\u003c/em\u003e\n    ALTER [ COLUMN ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecolumn_name\u003c/code\u003e\u003c/em\u003e SET ( \u003cem class=\"replaceable\"\u003e\u003ccode\u003eattribute_option\u003c/code\u003e\u003c/em\u003e = \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e [, ... ] )\n    ALTER [ COLUMN ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecolumn_name\u003c/code\u003e\u003c/em\u003e RESET ( \u003cem class=\"replaceable\"\u003e\u003ccode\u003eattribute_option\u003c/code\u003e\u003c/em\u003e [, ... ] )\n    ALTER [ COLUMN ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecolumn_name\u003c/code\u003e\u003c/em\u003e SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }\n    ALTER [ COLUMN ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecolumn_name\u003c/code\u003e\u003c/em\u003e SET COMPRESSION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ecompression_method\u003c/code\u003e\u003c/em\u003e\n    CLUSTER ON \u003cem class=\"replaceable\"\u003e\u003ccode\u003eindex_name\u003c/code\u003e\u003c/em\u003e\n    SET WITHOUT CLUSTER\n    SET ACCESS METHOD \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_access_method\u003c/code\u003e\u003c/em\u003e\n    SET TABLESPACE \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_tablespace\u003c/code\u003e\u003c/em\u003e\n    SET ( \u003cem class=\"replaceable\"\u003e\u003ccode\u003estorage_parameter\u003c/code\u003e\u003c/em\u003e [= \u003cem class=\"replaceable\"\u003e\u003ccode\u003evalue\u003c/code\u003e\u003c/em\u003e] [, ... ] )\n    RESET ( \u003cem class=\"replaceable\"\u003e\u003ccode\u003estorage_parameter\u003c/code\u003e\u003c/em\u003e [, ... ] )\n    OWNER TO { \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_owner\u003c/code\u003e\u003c/em\u003e | CURRENT_ROLE | CURRENT_USER | SESSION_USER }","synopsis_text":"ALTER MATERIALIZED VIEW [ IF EXISTS ] name\naction [, ... ]\nALTER MATERIALIZED VIEW name\n[ NO ] DEPENDS ON EXTENSION extension_name\nALTER MATERIALIZED VIEW [ IF EXISTS ] name\nRENAME [ COLUMN ] column_name TO new_column_name\nALTER MATERIALIZED VIEW [ IF EXISTS ] name\nRENAME TO new_name\nALTER MATERIALIZED VIEW [ IF EXISTS ] name\nSET SCHEMA new_schema\nALTER MATERIALIZED VIEW ALL IN TABLESPACE name [ OWNED BY role_name [, ... ] ]\nSET TABLESPACE new_tablespace [ NOWAIT ]\n\n其中 action 可以是以下之一：\n\nALTER [ COLUMN ] column_name SET STATISTICS integer\nALTER [ COLUMN ] column_name SET ( attribute_option = value [, ... ] )\nALTER [ COLUMN ] column_name RESET ( attribute_option [, ... ] )\nALTER [ COLUMN ] column_name SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }\nALTER [ COLUMN ] column_name SET COMPRESSION compression_method\nCLUSTER ON index_name\nSET WITHOUT CLUSTER\nSET ACCESS METHOD new_access_method\nSET TABLESPACE new_tablespace\nSET ( storage_parameter [= value] [, ... ] )\nRESET ( storage_parameter [, ... ] )\nOWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }"}},"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}