remove_columnstore_policy()

Remove a columnstore policy from a hypertable

Since 2.18.0

Remove a columnstore policy from a hypertable or continuous aggregate.

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

Samples

You see the columnstore policies in the informational views.

Remove the columnstore policy from the cpu table:
```
CALL remove_columnstore_policy('cpu');
```
Remove the columnstore policy from the cpu_weekly continuous aggregate:
```
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 hypertable or continuous aggregate 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 columnstore policy does not exist on `hypertable`

This function returns void.