51.75. pg_matviews — PostgreSQL 12

Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / 20devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3

Historical version. PostgreSQL 12 has reached end of support. 2024-11-21. See the current manual.

51.75. `pg_matviews`
Prev	Up	Chapter 51. System Catalogs	Home	Next

51.75. `pg_matviews`

The view pg_matviews provides access to useful information about each materialized view in the database.

Table 51.76. pg_matviews Columns

Name	Type	References	Description
`schemaname`	`name`	`pg_namespace.nspname`	Name of schema containing materialized view
`matviewname`	`name`	`pg_class.relname`	Name of materialized view
`matviewowner`	`name`	`pg_authid.rolname`	Name of materialized view's owner
`tablespace`	`name`	`pg_tablespace.spcname`	Name of tablespace containing materialized view (null if default for database)
`hasindexes`	`boolean`		True if materialized view has (or recently had) any indexes
`ispopulated`	`boolean`		True if materialized view is currently populated
`definition`	`text`		Materialized view definition (a reconstructed `SELECT` query)

Prev	Up	Next
51.74. `pg_locks`	Home	51.76. `pg_policies`

Read the upstream documentation. For corrections, first check the current manual.