pg_matviews
The view pg_matviews provides access to useful information about each materialized view in the database.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- view
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- schemaname, matviewname, matviewowner, tablespace, hasindexes, ispopulated, definition
- runtime verified
- false
- source
- english-manual
Definition PG 18
The view pg_matviews provides access to useful information about each materialized view in the database.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| schemaname | name | Nullable | Name of schema containing materialized view |
| matviewname | name | Nullable | Name of materialized view |
| matviewowner | name | Nullable | Name of materialized view's owner |
| tablespace | name | Nullable | Name of tablespace containing materialized view (null if default for database) |
| hasindexes | bool | Nullable | True if materialized view has (or recently had) any indexes |
| ispopulated | bool | Nullable | True if materialized view is currently populated |
| definition | text | Nullable | Materialized view definition (a reconstructed SELECT query) |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:feec4a3724eef2f28a402a9d2918f61b8b9c23c495ffce0cac1f1673d96c3808
Text language: en · catalog-bilingual-repair:feec4a3724eef2f28a402a9d2918f61b8b9c23c495ffce0cac1f1673d96c3808