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.

Examples

-- Rename the materialized view foo to bar.
openGauss=# ALTER MATERIALIZED VIEW foo RENAME TO bar;

Helpful Links

CREATE MATERIALIZED VIEW, CREATE INCREMENTAL MATERIALIZED VIEW, DROP MATERIALIZED VIEW, REFRESH INCREMENTAL MATERIALIZED VIEW, and REFRESH MATERIALIZED VIEW