---
title: show_tablespaces() | Tiger Data Docs
description: Show the tablespaces attached to a hypertable
---

Since [0.7.0](https://github.com/timescale/timescaledb/releases/tag/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.