Versions:

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

SELECT remove_retention_policy('conditions');

Removes the existing data retention policy for the conditions table.

Found an issue on this page?

Report an issue!

Related Content