PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM VIEWS

pg_matviews

Read PG 18 manual ↗

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

Kind: System views
Columns in this snapshot: 7
Definition source: English manual

Columns 7

Column	Type	Description / reference
`schemaname`	`name`	Name of schema containing materialized view pg_namespace.nspname
`matviewname`	`name`	Name of materialized view pg_class.relname
`matviewowner`	`name`	Name of materialized view's owner pg_authid.rolname
`tablespace`	`name`	Name of tablespace containing materialized view (null if default for database) pg_tablespace.spcname
`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)

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`schemaname`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`matviewname`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`matviewowner`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`tablespace`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`hasindexes`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`ispopulated`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`definition`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 1

PG 9.2 → 9.3added

Definition snapshot: english-manuals:b730c6cc4f1dff683ab29b1cfd3… · English manual source