remove_retention_policy()

Community

Remove a policy to drop chunks of a particular hypertable.

Required Arguments

NameTypeDescription
relationREGCLASSName of the hypertable or continuous aggregate from which to remove the policy

Optional Arguments

NameTypeDescription
if_existsBOOLEANSet to true to avoid throwing an error if the policy does not exist. Defaults to false.

Sample Usage

  1. SELECT remove_retention_policy('conditions');

Removes the existing data retention policy for the conditions table.