remove_columnstore_policy()

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');

The syntax is:

CALL remove_columnstore_policy(
    hypertable = '<hypertable_name>',
    if_exists = true | false
);

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`

⌘I