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