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

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)

Parent topic: System Catalogs Definitions

check-circle-line exclamation-circle-line close-line
Scroll to top icon