remove_retention_policy() Community

Remove a policy to drop chunks of a particular hypertable.

Required Arguments

NameDescription
relation(REGCLASS) Name of the hypertable or continuous aggregate from which to remove the policy

Optional Arguments

NameDescription
if_exists(BOOLEAN) Set 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.