—
NAME
DROP_MATERIALIZED_VIEW - remove a materialized view
SYNOPSIS
bash
DROP MATERIALIZED VIEW [ IF EXISTS ] \nname\n [, ...] [ CASCADE | RESTRICT ]DESCRIPTION
DROP MATERIALIZED VIEW drops an existing materialized view. To execute this command you must be the owner of the materialized view.
PARAMETERS
IF EXISTS
name
CASCADE
RESTRICT
EXAMPLES
This command will remove the materialized view called order_summary:
bash
DROP MATERIALIZED VIEW order_summary;COMPATIBILITY
DROP MATERIALIZED VIEW is a PostgreSQL extension.
SEE ALSO
CREATE MATERIALIZED VIEW (CREATE_MATERIALIZED_VIEW(7)), ALTER MATERIALIZED VIEW (ALTER_MATERIALIZED_VIEW(7)), REFRESH MATERIALIZED VIEW (REFRESH_MATERIALIZED_VIEW(7))