System Catalogs / System views
pg_matviews
Read the PG 18 manualThe view pg_matviews provides access to useful information about each materialized view in the database.
Reading PG 18current·documented in 15 of 24 versions, 9.3 to 20
- Kind
- System views
- Columns in this snapshot
- 7
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 7
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
schemaname | name | Name of schema containing materialized view pg_namespace.nspname |
matviewname | name | Name of materialized view pg_class.relname |
matviewowner | name | Name of materialized view's owner pg_authid.rolname |
tablespace | name | Name of tablespace containing materialized view (null if default for database) pg_tablespace.spcname |
hasindexes | bool | True if materialized view has (or recently had) any indexes |
ispopulated | bool | True if materialized view is currently populated |
definition | text | Materialized view definition (a reconstructed SELECT query) |
Column history across versions
Version history 1
- 9.2 → 9.3 added
Definition snapshot: english-manuals:2d999315155f22ac16fb17ff37e… · English manual source