The view pg_matviews provides access to useful information about each materialized view in the database.
Table 49-65. pg_matviews Columns
|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)|
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.