detach_tablespaces()

Detach all tablespaces from a hypertable. After issuing this command on a hypertable, it no longer has any tablespaces attached to it. New chunks are instead placed in the database’s default tablespace.

Required arguments

NameTypeDescription
hypertableREGCLASSHypertable to detach a the tablespace from.

Sample usage

Detach all tablespaces from the hypertable conditions:

  1. SELECT detach_tablespaces('conditions');