HomeMogDBMogDB StackUqbar
v2.0

Documentation:v2.0

Supported Versions:

Other Versions:

GS_MATVIEWS

GS_MATVIEWS provides information about each materialized view in the database.

Table 1 GS_MATVIEWS columns

Name Type Reference Description
schemaname name PG_NAMESPACE.nspname Name of the schema of a materialized view.
matviewname name PG_CLASS.relname Name of a materialized view.
matviewowner name PG_AUTHID.Erolname Owner of a materialized view.
tablespace name PG_TABLESPACE.spcname Tablespace name of a materialized view. If the default tablespace of the database is used, the value is null.
hasindexes boolean - This column is true if the materialized view has (or has recently had) any indexes.
definition text - Definition of a materialized view (a reconstructed SELECT query).
Copyright © 2011-2024 www.enmotech.com All rights reserved.