Contents
CREATE MATERIALIZED VIEW
A DDL command for defining a materialized view
CREATE MATERIALIZED VIEW
is a DDL command for defining a materialized view.
CREATE MATERIALIZED VIEW
was added in PostgreSQL 9.3.
Change history
- PostgreSQL 13
USING method
syntax added (commit 8586bf7e)
- PostgreSQL 9.5
CREATE MATERIALIZED VIEW IF NOT EXISTS
syntax added (commit e39b6f95)
- PostgreSQL 9.3
- added (commit 3bf3ab8c)
References
- PostgreSQL documentation: CREATE MATERIALIZED VIEW