Continuous aggregate views can be dropped using the
DROP MATERIALIZED VIEW statement.
This statement deletes the continuous aggregate and all its internal
objects. To also delete other dependent objects, such as a view
defined on the continuous aggregate, add the
option. Dropping a continuous aggregate does not affect the data in
the underlying hypertable from which the continuous aggregate is
DROP MATERIALIZED VIEW <view_name>;
|TEXT||Name (optionally schema-qualified) of continuous aggregate view to be created.|
Drop existing continuous aggregate.
DROP MATERIALIZED VIEW contagg_view;