remove_retention_policy()

Remove a retention policy from a hypertable

Community Since 1.2.0

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

The syntax is:

SELECT remove_retention_policy(
    relation = '<hypertable_or_cagg_name>',
    if_exists = true | false
);

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.

Returns

This function returns void.