detach_tablespaces()

Detach all tablespaces from a hypertable

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

Samples

Detach all tablespaces from the conditions:

SELECT detach_tablespaces('conditions');

Arguments

The syntax is:

SELECT detach_tablespaces(
    hypertable = '<hypertable_name>'
);

Name	Type	Default	Required	Description
hypertable	REGCLASS	-	✔	Hypertable to detach a the tablespace from.