Use the SHOW VIEW
command to list existing views in a particular schema.
Parameter or clause | Description |
---|---|
schema_name | The schema from which existing views will be listed. If not given, 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. |
t3
in the public
schema and a view v3
.
SHOW VIEWS
to show the existing views.