remove_retention_policy()

Remove a policy to drop chunks of a particular hypertable.

Required arguments

Name Type Description
relation REGCLASS Name of the hypertable or continuous aggregate from which to remove the policy

Optional arguments

Name Type Description
if_exists BOOLEAN Set to true to avoid throwing an error if the policy does not exist. Defaults to false.

Sample usage

2. SELECT remove_retention_policy('conditions');

Removes the existing data retention policy for the conditions table.