remove_continuous_aggregate_policy()

Remove the refresh policy from a continuous aggregate.

2. remove_continuous_aggregate_policy(

4. continuous_aggregate REGCLASS,

6. if_exists BOOL = NULL

8. ) RETURNS VOID

To view the existing continuous aggregate policies, see the policies informational view.

Required arguments

Name	Type	Description
`continuous_aggregate`	`REGCLASS`	Name of the continuous aggregate the policy should be removed from

Name	Type	Description
`if_exists` (formerly `if_not_exists`)	`BOOL`	When true, prints a warning instead of erroring if the policy doesn’t exist. Defaults to false. Renamed in TimescaleDB 2.8.

Remove the refresh policy from the cpu_view continuous aggregate:

2. SELECT remove_continuous_aggregate_policy('cpu_view');