Commands
SHOW MATERIALIZED VIEWS
Use the SHOW MATERIALZED VIEWS
command to show existing materialized views.
Syntax
Parameters
Parameter | Description |
---|---|
schema_name | The schema in which the materialized views will be listed. If not given, materialized views from the default schema, public, will be listed |
LIKE_expression | Filters the output based on names by applying pattern matching. See details in LIKE pattern matching expressions. |
Example
Was this page helpful?