Help Center/
GaussDB/
Developer Guide(Centralized_V2.0-3.x)/
System Catalogs and System Views/
System Views/
GS_MATVIEWS
Updated on 2025-08-19 GMT+08:00
GS_MATVIEWS
GS_MATVIEWS provides information about each materialized view in the database.
|
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 a materialized view has (or has recently had) any indexes. |
|
definition |
text |
- |
Definition of a materialized view (a reconstructed SELECT query) |
Parent topic: System Views
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.
