pg_matviews
A system catalogue view listing the available materialized views
pg_matviews is a system catalogue view listing the available materialized views.
pg_matviews was added in PostgreSQL 9.3 (commit 3bf3ab8c).
Definition by PostgreSQL version
pg_matviews (PostgreSQL 13)
View "pg_catalog.pg_matviews"
Column | Type | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
schemaname | name | | |
matviewname | name | | |
matviewowner | name | | |
tablespace | name | | |
hasindexes | boolean | | |
ispopulated | boolean | | |
definition | text | | |
Documentation: pg_matviews
pg_matviews (PostgreSQL 12)
View "pg_catalog.pg_matviews"
Column | Type | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
schemaname | name | | |
matviewname | name | | |
matviewowner | name | | |
tablespace | name | | |
hasindexes | boolean | | |
ispopulated | boolean | | |
definition | text | | |
Documentation: pg_matviews
pg_matviews (PostgreSQL 11)
View "pg_catalog.pg_matviews"
Column | Type | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
schemaname | name | | |
matviewname | name | | |
matviewowner | name | | |
tablespace | name | | |
hasindexes | boolean | | |
ispopulated | boolean | | |
definition | text | | |
Documentation: pg_matviews
pg_matviews (PostgreSQL 10)
View "pg_catalog.pg_matviews"
Column | Type | Collation | Nullable | Default
--------------+---------+-----------+----------+---------
schemaname | name | | |
matviewname | name | | |
matviewowner | name | | |
tablespace | name | | |
hasindexes | boolean | | |
ispopulated | boolean | | |
definition | text | | |
Documentation: pg_matviews
pg_matviews (PostgreSQL 9.6)
View "pg_catalog.pg_matviews"
Column | Type | Modifiers
--------------+---------+-----------
schemaname | name |
matviewname | name |
matviewowner | name |
tablespace | name |
hasindexes | boolean |
ispopulated | boolean |
definition | text |
Documentation: pg_matviews
pg_matviews (PostgreSQL 9.5)
View "pg_catalog.pg_matviews"
Column | Type | Modifiers
--------------+---------+-----------
schemaname | name |
matviewname | name |
matviewowner | name |
tablespace | name |
hasindexes | boolean |
ispopulated | boolean |
definition | text |
Documentation: pg_matviews
pg_matviews (PostgreSQL 9.4)
View "pg_catalog.pg_matviews"
Column | Type | Modifiers
--------------+---------+-----------
schemaname | name |
matviewname | name |
matviewowner | name |
tablespace | name |
hasindexes | boolean |
ispopulated | boolean |
definition | text |
Documentation: pg_matviews
pg_matviews (PostgreSQL 9.3)
View "pg_catalog.pg_matviews"
Column | Type | Modifiers
--------------+---------+-----------
schemaname | name |
matviewname | name |
matviewowner | name |
tablespace | name |
hasindexes | boolean |
ispopulated | boolean |
definition | text |
Documentation: pg_matviews
Change history
This view has not been modified since it was added in PostgreSQL 9.3.
- PostgreSQL 9.3
- added (commit 3bf3ab8c)
References
- PostgreSQL documentation: pg_matviews