remove_reorder_policy.md

api_name	excerpt	topics	keywords	tags	api
remove_reorder_policy()	Remove a reorder policy from a hypertable	hypertables jobs	reorder policies remove	delete drop	license type community function

remove_reorder_policy() Community

Remove a policy to reorder a particular hypertable.

Required arguments

Name	Type	Description
hypertable	REGCLASS	Name of the hypertable from which to remove the policy.

Optional arguments

Name	Type	Description
if_exists	BOOLEAN	Set to true to avoid throwing an error if the reorder_policy does not exist. A notice is issued instead. Defaults to false.

Sample usage

SELECT remove_reorder_policy('conditions', if_exists => true);

removes the existing reorder policy for the conditions table if it exists.