show_tablespaces()

Since 0.7.0 Show the tablespaces attached to a .

Samples

SELECT * FROM show_tablespaces('conditions');

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

The syntax is:

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

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

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

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