PostgreSQL

PostgreSQL Elephant Logo

52.74. pg_matviews

The view pg_matviews provides access to useful information about each materialized view in the database.

Table 52.75. pg_matviews Columns

Name Type References Description

schemaname

name

pg_namespace.nspname

Name of schema containing materialized view

matviewname

name

pg_class.relname

Name of materialized view

matviewowner

name

pg_authid.rolname

Name of materialized view’s owner

tablespace

name

pg_tablespace.spcname

Name of tablespace containing materialized view (null if default for database)

hasindexes

boolean

True if materialized view has (or recently had) any indexes

ispopulated

boolean

True if materialized view is currently populated

definition

text

Materialized view definition (a reconstructed SELECT query)

+

Prev Up Next

52.73. pg_locks

Home

52.75. pg_policies

Copyright © 1996-2023 The PostgreSQL Global Development Group