GS_MATVIEW

GS_MATVIEW provides information about each materialized view in the database.

**Table 1** GS_MATVIEW columns
Name	Type	Description
oid	oid	Row identifier (hidden attribute, which must be specified).
matviewid	oid	OID of a materialized view.
mapid	oid	OID of a map table associated with a materialized view. Each map table corresponds to one materialized view. If a complete-refresh materialized view does not correspond to a map table, the value of this column is 0.
ivm	boolean	Type of a materialized view. The value t indicates a fast-refresh materialized view, and the value f indicates a complete-refresh materialized view.
needrefresh	boolean	Reserved column.
refreshtime	timestamp without time zone	Last time when a materialized view was refreshed. If the materialized view is not refreshed, the value is null. This column is maintained only for fast-refresh materialized views on DNs. In other cases, the value is null.