Browse categories
PostgreSQL releases
- PostgreSQL 14 (dev)
- PostgreSQL 13 (latest)
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10
- PostgreSQL 9.6
- PostgreSQL 9.5 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Progress reporting views
Contrib modules
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Categories
See also

REFRESH MATERIALIZED VIEW

A DDL command to update a materialized view

REFRESH MATERIALIZED VIEW is a DDL command to update a materialized view.

REFRESH MATERIALIZED VIEW was added in PostgreSQL 9.3.

Change history

PostgreSQL 9.4
- REFRESH MATERIALIZED VIEW CONCURRENTLY added (commit cc1965a9)
PostgreSQL 9.3
- added (commit 3bf3ab8c)

References

PostgreSQL documentation: REFRESH MATERIALIZED VIEW

Categories

See also

CREATE MATERIALIZED VIEW, DROP MATERIALIZED VIEW