Skip to main content
Since 0.7.0 Show the tablespaces attached to a .

Samples

SELECT * FROM show_tablespaces('conditions');

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

Arguments

The syntax is:
SELECT show_tablespaces(
    hypertable = '<hypertable_name>'
);
NameTypeDefaultRequiredDescription
hypertableREGCLASS- to show attached tablespaces for.

Returns

ColumnTypeDescription
show_tablespacesNAMEThe 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.