Skip to main content

SHOW MATERIALIZED VIEWS

Use the SHOW MATERIALZED VIEWS command to show existing materialized views.

Syntax

SHOW MATERIALIZED VIEWS [FROM schema_name];

Parameters

ParameterDescription
schema_nameThe schema in which the materialized views will be listed. If not given, materialized views from the default schema, "public", will be listed

Example

SHOW MATERIALIZED VIEWS FROM schema_1;

Help us make this doc better!