53.14. pg_matviews #

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

   Table 53.14. pg_matviews Columns

   Column Type

   Description

   schemaname name (references pg_namespace.nspname)

   Name of schema containing materialized view

   matviewname name (references pg_class.relname)

   Name of materialized view

   matviewowner name (references pg_authid.rolname)

   Name of materialized view's owner

   tablespace name (references pg_tablespace.spcname)

   Name of tablespace containing materialized view (null if default for
   database)

   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)