Skip to content
masterclass Buddy
Start learning

PostgreSQL · Command

CREATE MATERIALIZED VIEW

CREATE MATERIALIZED VIEW stores the result of a query in a table-like object. PostgreSQL remembers the query so you can rebuild the stored data with REFRESH MATERIALIZED VIEW.

Last updated

Syntax

CREATE MATERIALIZED VIEW [ IF NOT EXISTS ] table_name [ ( column_name [, ...] ) ] [ USING method ] [ WITH ( storage_parameter [= value ] [, ... ] ) ] [ TABLESPACE tablespace_name ] AS query [ WITH [ NO ] DATA ]

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

Subscribe
  • ALTER MATERIALIZED VIEW
  • CREATE TABLE AS
  • CREATE VIEW
  • DROP MATERIALIZED VIEW
  • REFRESH MATERIALIZED VIEW

Source: PostgreSQL: Documentation: 18: CREATE MATERIALIZED VIEW. Checked 2026-11-03.