Versions:

detach_tablespaces()

Detach all tablespaces from a hypertable. After issuing this command on a hypertable, it will no longer have any tablespaces attached to it. New chunks will instead be 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:

SELECT detach_tablespaces('conditions');

Found an issue on this page?

Report an issue!