remove_retention_policy()

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

  2. SELECT remove_retention_policy('conditions');

Removes the existing data retention policy for the conditions table.