Skip to content
masterclass Buddy
Start learning

PostgreSQL · Command

REFRESH MATERIALIZED VIEW

REFRESH MATERIALIZED VIEW replaces all stored rows in a materialized view. By default it runs the saved query and leaves the view readable; WITH NO DATA leaves it unreadable.

Last updated

Syntax

REFRESH MATERIALIZED VIEW [ CONCURRENTLY ] name [ WITH [ NO ] DATA ]

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

Subscribe
  • CREATE MATERIALIZED VIEW
  • ALTER MATERIALIZED VIEW
  • DROP MATERIALIZED VIEW

Source: REFRESH MATERIALIZED VIEW. Checked 2026-11-03.