API ReferenceData retentionremove_retention_policy
Versions:

remove_retention_policy()
Community
Community functions are available under Timescale Community Edition. Click to learn more.

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!
Previousadd_retention_policyNextActions and automation

Related Content

remove_continuous_aggregate_policy
Remove refresh policy for a continuous aggregate
add_retention_policy
Create a policy to drop chunks older than a given interval of a particular hypertable or continuous aggregate on a schedule in the background
remove_compression_policy
If you need to remove the compression policy
remove_reorder_policy
Remove a policy to reorder a particular hypertable