HomeMogDBMogDB StackUqbar
v2.1

Documentation:v2.1

Supported Versions:

Other Versions:

GS_MATVIEW_DEPENDENCY

GS_MATVIEW_DEPENDENCY provides association information about the base table and mlog table of each materialized view in the database.

Table 1 GS_MATVIEW_DEPENDENCY columns

Name Type Description
oid oid Row identifier (hidden attribute, which must be specified)
matviewid oid OID of a materialized view.
relid oid OID of a base table of a materialized view.
mlogid oid OID of a mlog table which is the log table of a materialized view. Each mlog table corresponds to one base table.
mxmin int4 Reserved column
Copyright © 2011-2024 www.enmotech.com All rights reserved.