remove_columnstore_policy()

remove a columnstore policy from a hypertable

Since 2.18.0

Remove a policy from a or .

To restart automatic migration to the , you need to call add_columnstore_policy again.

Samples

You see the policies in the informational views.

• Remove the policy from the cpu table:

  CALL remove_columnstore_policy('cpu');
  

• Remove the policy from the cpu_weekly :

  CALL remove_columnstore_policy('cpu_weekly');
  

Arguments

Name	Type	Default	Required	Description
hypertable	REGCLASS	-	✔	Name of the or to remove the policy from
if_exists	BOOLEAN	false	✖	Set to true so this job fails with a warning rather than an error if a policy does not exist on hypertable