ALTER MATERIALIZED VIEW

ALTER MATERIALIZED VIEW — Change the Definition of a Materialized View

Synopsis

ALTER MATERIALIZED VIEW [ IF EXISTS ] name

action [, ... ]

ALTER MATERIALIZED VIEW name

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 }

CLUSTER ON index_name

SET WITHOUT CLUSTER

SET ( storage_parameter [= value] [, ... ] )

RESET ( storage_parameter [, ... ] )

OWNER TO { new_owner | CURRENT_USER | SESSION_USER }

Description

ALTER MATERIALIZED VIEW changes multiple auxiliary properties of an existing materialized view.

To use ALTER MATERIALIZED VIEW, you must own the materialized view. To change the schema of a materialized view, you must also have CREATE privilege on the new schema. To change 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 schema containing the materialized view (these restrictions enforce that changing the owner cannot do anything you couldn't do by dropping and recreating the materialized view. However, a superuser can change ownership of any view).

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

Parameters

name

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

column_name

The name of a new or existing column.

extension_name

The name of the extension on which the materialized view depends (or if NO is specified, no longer depends on). Materialized views marked as dependent on an extension are automatically dropped when the extension is dropped.

new_column_name

The 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;

See Also

CREATE MATERIALIZED VIEW,DROP MATERIALIZED VIEW,REFRESH MATERIALIZED VIEW