pg_matviews

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

Column Type References Description

Column	Type	References	Description
schemaname	name	pg_namespace.nspname	Name of the schema containing the materialized view
matviewname	name	pg_class.relname	Name of the materialized view
matviewowner	name	pg_authid.rolname	Name of the materialized view’s owner
tablespace	name	pg_tablespace.spcname	Name of the tablespace containing the materialized view (`NULL` if default for the database)
hasindexes	boolean	—	`true` if the materialized view has (or recently had) any indexes
ispopulated	boolean	—	`true` if the materialized view is currently populated
definition	text	—	Materialized view definition (a reconstructed `SELECT` command)

schemaname

name

pg_namespace.nspname

Name of the schema containing the materialized view

matviewname

name

pg_class.relname

Name of the materialized view

matviewowner

name

pg_authid.rolname

Name of the materialized view’s owner

tablespace

name

pg_tablespace.spcname

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

hasindexes

boolean

—

true if the materialized view has (or recently had) any indexes

ispopulated

boolean

—

true if the materialized view is currently populated

definition

text

—

Materialized view definition (a reconstructed SELECT command)