Contents
ALTER MATERIALIZED VIEW
An SQL command for modifiying the definition of a materialized view
ALTER MATERIALIZED VIEW
is a DDL command for modifiying the definition of a materialized view.
ALTER MATERIALIZED VIEW
was added in PostgreSQL 9.3.
Change history
- PostgreSQL 13
- PostgreSQL 9.6
DEPENDS ON EXTENSION
syntax added (commit f2fcad27)
- PostgreSQL 9.4
ALTER MATERIALIZED VIEW ALL IN TABLESPACE ... SET TABLESPACE ...
syntax added (commit d9b2bc45)
- PostgreSQL 9.3
- added (commit 3bf3ab8c)
References
- PostgreSQL documentation: ALTER MATERIALIZED VIEW