PG_MATVIEWS
PG_MATVIEWS provides information about each materialized view in the database.
Table 1 PG_MATVIEWS columns
PG_NAMESPACE.nspname | |||
PG_CLASS.relname | |||
PG_AUTHID.Erolname | |||
PG_TABLESPACE.spcname | Tablespace name of the materialized view. If the default tablespace of the database is used, the value is null. | ||
This column is true if the materialized view has (or has recently had) any indexes. | |||
Definition of a materialized view (a reconstructed SELECT query). |
Feedback