Help Center/
GaussDB/
Developer Guide(Centralized_V2.0-2.x)/
System Catalogs and System Views/
System Catalogs/
GS_MATVIEW_DEPENDENCY
Updated on 2025-08-19 GMT+08:00
GS_MATVIEW_DEPENDENCY
GS_MATVIEW_DEPENDENCY provides association information about each fast-refresh materialized view, base table, and Mlog table in the database. The Mlog table corresponding to the base table does not exist in the complete-refresh materialized view. Therefore, no record is written into the Mlog table.
|
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 |
Parent topic: System Catalogs
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
