PostgreSQL Cheat Sheet/Refresh materialized view

Update a materialized view's contents.

Section: Views, Functions, Triggers, and Extensions

Refresh materialized view

sql
sql
REFRESH MATERIALIZED VIEW CONCURRENTLY daily_sales;
Explanation

Requires a unique index for concurrent refresh.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Views, Functions, Triggers, and Extensions
Connect to a database
Open an interactive psql session to a database.
Create database
Create a new database in the cluster.
Create schema
Create a namespace for objects.
Insert row
Insert one row into a table.
Basic SELECT
Fetch a sorted subset of rows.
Create index
Add a basic B-tree index to speed lookups.