ALTER MATERIALIZED VIEW
Function
ALTER MATERIALIZED VIEW changes multiple auxiliary attributes of an existing materialized view.
Statements and actions that can be used for ALTER MATERIALIZED VIEW are a subset of ALTER TABLE and have the same meaning when used for materialized views. For details, see ALTER TABLE.
Precautions
- Only the owner of a materialized view or a system administrator has the ALTER TMATERIALIZED VIEW permission.
- The materialized view structure cannot be modified.
Syntax
Change the owner of the materialized view.
ALTER MATERIALIZED VIEW [ IF EXISTS ] mv_name OWNER TO new_owner;
Modify the column of a materialized view.
ALTER MATERIALIZED VIEW [ IF EXISTS ] mv_name RENAME [ COLUMN ] column_name TO new_column_name;
Rename a materialized view.
ALTER MATERIALIZED VIEW [ IF EXISTS ] mv_name RENAME TO new_name;
Parameter Description
mv_name
Specifies the name of an existing materialized view, which can be schema-qualified.
Value range: a string. It must comply with the naming convention.
column_name
Specifies the name of a new or existing column.
Value range: a string. It must comply with the naming convention.
new_column_name
Specifies the new name of an existing column.
new_owner
Specifies the user name of the new owner of a materialized view.
new_name
Specifies the new name of a materialized view.
Example
-- Rename the materialized view foo to bar.
postgres=# ALTER MATERIALIZED VIEW foo RENAME TO bar;
Helpful Links
CREATE MATERIALIZED VIEW, CREATE INCREMENTAL MATERIALIZED VIEW, DROP MATERIALIZED VIEW, REFRESH INCREMENTAL MATERIALIZED VIEW, REFRESH MATERIALIZED VIEW