52.74. pg_matviews

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

Table 52.75. 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)