GS_MATVIEWS

GS_MATVIEWS provides information about each materialized view in the database.

Table 1 GS_MATVIEWS columns

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)

Feedback
编组 3备份
    openGauss 2024-07-13 01:01:39
    cancel