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 methodsyntax added (commit 8586bf7e)
- PostgreSQL 9.5
CREATE MATERIALIZED VIEW IF NOT EXISTSsyntax added (commit e39b6f95)
- PostgreSQL 9.3
- added (commit 3bf3ab8c)
References
- PostgreSQL documentation: CREATE MATERIALIZED VIEW