Help Center> GaussDB> Distributed_8.x> System Catalogs and System Views> System Views> Materialized Views> GS_MATVIEWS
Updated on 2024-06-03 GMT+08:00
View PDF

GS_MATVIEWS

GS_MATVIEWS displays information about each materialized view in the database.

Table 1 GS_MATVIEWS columns

Name

Type

Reference

Description

schemaname

name

nspname in PG_NAMESPACE

Name of the schema of a materialized view.

matviewname

name

relname in PG_CLASS

Name of a materialized view.

matviewowner

name

rolname in PG_AUTHID

Owner of a materialized view.

tablespace

name

spcname in PG_TABLESPACE

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: Materialized Views