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

Table 53.14. pg_matviews Columns

| Column Type

Description

| | --- | |

schemaname name (references pg_namespace.nspname)

Name of schema containing materialized view

| |

matviewname name (references pg_class.relname)

Name of materialized view

| |

matviewowner name (references pg_authid.rolname)

Name of materialized view's owner

| |

tablespace name (references pg_tablespace.spcname)

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

| |

hasindexes bool

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

| |

ispopulated bool

True if materialized view is currently populated

| |

definition text

Materialized view definition (a reconstructed SELECT query)

|