49.66. pg_matviews

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

Table 49-67. pg_matviews Columns

NameTypeReferencesDescription
schemanamenamepg_namespace.nspnameName of schema containing materialized view
matviewnamenamepg_class.relnameName of materialized view
matviewownernamepg_authid.rolnameName of materialized view's owner
tablespacenamepg_tablespace.spcnameName of tablespace containing materialized view (null if default for database)
hasindexesboolean True if materialized view has (or recently had) any indexes
ispopulatedboolean True if materialized view is currently populated
definitiontext Materialized view definition (a reconstructed SELECT query)