remove_retention_policy()

Remove a retention policy from a hypertable

Community

Remove a policy to drop s of a particular .

Samples

SELECT remove_retention_policy('conditions');

Removes the existing data retention policy for the conditions table.

Arguments

Name	Type	Default	Required	Description
relation	REGCLASS	-	✔	Name of the hypertable or continuous aggregate from which to remove the policy
if_exists	BOOLEAN	false	-	Set to true to avoid throwing an error if the policy does not exist.