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

Sample usage

Detach all tablespaces from the hypertable conditions:

2. SELECT detach_tablespaces('conditions');