Browse categories
Random entry
PostgreSQL releases
- PostgreSQL 16 (dev)
- PostgreSQL 15 (latest)
- PostgreSQL 14
- PostgreSQL 13
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Contrib modules
Object Identifier Types
Progress reporting views
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL
Abbreviations and acronyms

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Categories
See also

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 14
- ALTER MATERIALIZED VIEW ... OWNER TO CURRENT_ROLE syntax added (commit 45b98057)
PostgreSQL 13
- ALTER MATERIALIZED VIEW ... RENAME COLUMN returns ALTER MATERIALIZED VIEW (instead of ALTER TABLE) on successful command completion (commit 979766c0)
- NO DEPENDS ON EXTENSION syntax added (commit 5fc70394)
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

Categories

See also

CREATE MATERIALIZED VIEW, DROP MATERIALIZED VIEW