pg_matviews
   The view pg_matviews provides access to
   useful information about each materialized view in the database.
  
Table 52.76. pg_matviews Columns
Column Type Description  | 
|---|
        Name of schema containing materialized view  | 
        Name of materialized view  | 
        Name of materialized view's owner  | 
        Name of tablespace containing materialized view (null if default for database)  | 
        True if materialized view has (or recently had) any indexes  | 
        True if materialized view is currently populated  | 
        Materialized view definition (a reconstructed SELECT query)  |