PostgreSQL

PostgreSQL Elephant Logo

51.75. pg_matviews

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

Table 51.76. 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

51.74. pg_locks

Home

51.76. pg_policies

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Copyright © 1996-2023 The PostgreSQL Global Development Group