> ## Documentation Index
> Fetch the complete documentation index at: https://mintlify-poc.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# show_tablespaces()

> Show the tablespaces attached to a hypertable

export const CHUNK_CAP = 'Chunk';

export const CHUNK = 'chunk';

export const HYPERTABLE_CAP = 'Hypertable';

export const HYPERTABLE = 'hypertable';

<Icon icon="tag" iconType="duotone" /> Since [0.7.0][tsdb-0.7.0]

Show the tablespaces attached to a {HYPERTABLE}.

## Samples

```sql theme={"dark"}
SELECT * FROM show_tablespaces('conditions');

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

## Arguments

The syntax is:

```sql theme={"dark"}
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.

[tsdb-0.7.0]: https://github.com/timescale/timescaledb/releases/tag/0.7.0