Drop a continuous aggregate view
You can drop a continuous aggregate view using the DROP MATERIALIZED VIEW command. This command also removes refresh policies defined on the continuous aggregate. It does not drop the data from the underlying hypertable.
Dropping a continuous aggregate view
- From the
psqlprompt, drop the view: