Help Center/ GaussDB/ Developer Guide(Distributed_2.x)/ System Catalogs and System Views/ System Views/ GS_MATVIEWS
Updated on 2023-10-23 GMT+08:00
View PDF
Share

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