show_tablespaces()

Since 0.7.0

Show the tablespaces attached to a hypertable.

Samples

SELECT * FROM show_tablespaces('conditions');

 show_tablespaces
------------------
 disk1
 disk2

Arguments

The syntax is:

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

Name	Type	Default	Required	Description
hypertable	REGCLASS	-	✔	hypertable to show attached tablespaces for.

Returns

Column	Type	Description
show_tablespaces	NAME	The name of each tablespace attached to the hypertable. Returns one row per attached tablespace.

The function returns a set of tablespace names. If no tablespaces are attached to the hypertable, the function returns an empty result set.