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 ] [ LIKE_expression ];

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
LIKE_expressionFilters the output based on names by applying pattern matching. See details in LIKE pattern matching expressions.

Example

SHOW MATERIALIZED VIEWS FROM schema_1;

Help us make this doc better!