# phpman > man > ALTER_MATERIALIZED_VIEW(7)

ALTER MATERIALIZED [VIEW(7)](https://www.chedong.com/phpMan.php/man/VIEW/7/markdown)         PostgreSQL 14.23 Documentation         ALTER MATERIALIZED [VIEW(7)](https://www.chedong.com/phpMan.php/man/VIEW/7/markdown)



## NAME
       ALTER_MATERIALIZED_VIEW - change the definition of a materialized view

## SYNOPSIS
       ALTER MATERIALIZED VIEW [ IF EXISTS ] _name_
           _action_ [, ... ]
       ALTER MATERIALIZED VIEW _name_
           [ NO ] DEPENDS ON EXTENSION _extension_name_
       ALTER MATERIALIZED VIEW [ IF EXISTS ] _name_
           RENAME [ COLUMN ] _column_name_ TO _new_column_name_
       ALTER MATERIALIZED VIEW [ IF EXISTS ] _name_
           RENAME TO _new_name_
       ALTER MATERIALIZED VIEW [ IF EXISTS ] _name_
           SET SCHEMA _new_schema_
       ALTER MATERIALIZED VIEW ALL IN TABLESPACE _name_ [ OWNED BY _role_name_ [, ... ] ]
           SET TABLESPACE _new_tablespace_ [ NOWAIT ]

       where _action_ is one of:

           ALTER [ COLUMN ] _column_name_ SET STATISTICS _integer_
           ALTER [ COLUMN ] _column_name_ SET ( _attribute_option_ = _value_ [, ... ] )
           ALTER [ COLUMN ] _column_name_ RESET ( _attribute_option_ [, ... ] )
           ALTER [ COLUMN ] _column_name_ SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }
           ALTER [ COLUMN ] _column_name_ SET COMPRESSION _compression_method_
           CLUSTER ON _index_name_
           SET WITHOUT CLUSTER
           SET TABLESPACE _new_tablespace_
           SET ( _storage_parameter_ [= _value_] [, ... ] )
           RESET ( _storage_parameter_ [, ... ] )
           OWNER TO { _new_owner_ | CURRENT_ROLE | CURRENT_USER | SESSION_USER }

## DESCRIPTION
       **ALTER** **MATERIALIZED** **VIEW** changes various auxiliary properties of an existing materialized
       view.

       You must own the materialized view to use **ALTER** **MATERIALIZED** **VIEW**. To change a materialized
       view's schema, you must also have CREATE privilege on the new schema. To alter the owner, you
       must also be a direct or indirect member of the new owning role, and that role must have
       CREATE 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.)

       The statement subforms and actions available for **ALTER** **MATERIALIZED** **VIEW** are a subset of
       those available for **ALTER** **TABLE**, and have the same meaning when used for materialized views.
       See the descriptions for **ALTER** **TABLE** for details.

## PARAMETERS
       _name_
           The name (optionally schema-qualified) of an existing materialized view.

       _column_name_
           Name of an existing column.

       _extension_name_
           The name of the extension that the materialized view is to depend on (or no longer
           dependent on, if NO is specified). A materialized view that's marked as dependent on an
           extension is automatically dropped when the extension is dropped.

       _new_column_name_
           New name for an existing column.

       _new_owner_
           The user name of the new owner of the materialized view.

       _new_name_
           The new name for the materialized view.

       _new_schema_
           The new schema for the materialized view.

## EXAMPLES
       To rename the materialized view foo to bar:

           ALTER MATERIALIZED VIEW foo RENAME TO bar;

## COMPATIBILITY
       **ALTER** **MATERIALIZED** **VIEW** is a PostgreSQL extension.

## SEE ALSO
       CREATE MATERIALIZED VIEW (**CREATE**___**MATERIALIZED**___**[VIEW**(7)](https://www.chedong.com/phpMan.php/man/VIEW/7/markdown)), DROP MATERIALIZED VIEW
       (**DROP**___**MATERIALIZED**___**[VIEW**(7)](https://www.chedong.com/phpMan.php/man/VIEW/7/markdown)), REFRESH MATERIALIZED VIEW (**REFRESH**___**MATERIALIZED**___**[VIEW**(7)](https://www.chedong.com/phpMan.php/man/VIEW/7/markdown))



PostgreSQL 14.23                                2026                      ALTER MATERIALIZED [VIEW(7)](https://www.chedong.com/phpMan.php/man/VIEW/7/markdown)