top of page
CerebroSQL

PostgreSQL:  

REFRESH MATERIALIZED VIEW

Topic

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

Example

REFRESH MATERIALIZED VIEW order_summary;
REFRESH MATERIALIZED VIEW annual_statistics_basis WITH NO DATA;

bottom of page