Help Center> GaussDB> Distributed_2.x> System Catalogs and System Views> System Views> GS_MATVIEWS

Updated on 2023-10-23 GMT+08:00

View PDF

GS_MATVIEWS

GS_MATVIEWS stores metadata of all materialized views.

**Table 1** GS_MATVIEWS columns
Name	Type	Description
schemaname	name	Schema to which the materialized view belongs
matviewname	name	Name of a materialized view
matviewowner	name	Owner of the materialized view
tablespace	name	Tablespace to which the materialized view belongs
hasindexes	boolean	Whether an index exists in the materialized view t (true): yes. f (false): no.
definition	text	Action statement of the materialized view

Parent topic: System Views

Previous topic: GS_MATVIEWS

Next topic: GS_SESSION_CPU_STATISTICS

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.