pg_matviews

A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.

pg_matviews

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

Table 1. pg_catalog.pg_conversion
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)