GS_MATVIEWS
GS_MATVIEWS provides information about each materialized view in the database.
Table 1 GS_MATVIEWS columns
PG_NAMESPACE.nspname | |||
PG_CLASS.relname | |||
PG_AUTHID.Erolname | |||
PG_TABLESPACE.spcname | Tablespace name of a 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