detach_tablespaces()

Detach all tablespaces from a hypertable

Since 0.7.0

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 the tablespace from.

Returns

Name	Type	Description
detach_tablespaces	INTEGER	The total number of tablespaces that were detached from the .