Skip to content
🚀 Agentic Postgres: The first database built for agents 🤖
TimescaleDB - Timeseries database for PostgreSQL Docs
  • tigerdata.com
  • Try for free
Get started
Try the key Tiger Data features
Start coding with Tiger Data
Create a Tiger Cloud service
About Tiger Data products
Tiger Data architecture for real-time analytics
Pricing plans and account management
Feature comparison
Use Tiger Data products
Hypertables
Hypercore
Continuous aggregates
Tutorials
Integrations
API Reference
Hypertables and chunks
CREATE TABLE
create_hypertable
create_hypertable (old API)
show_chunks
drop_chunks
reorder_chunk
split_chunk
merge_chunks
move_chunk
detach_chunk
attach_chunk
add_reorder_policy
remove_reorder_policy
attach_tablespace
detach_tablespace
detach_tablespaces
show_tablespaces
set_chunk_time_interval
set_integer_now_func
add_dimension
add_dimension (old interface)
enable_chunk_skipping
disable_chunk_skipping
create_index (transaction per chunk)
hypertable_size
hypertable_approximate_size
hypertable_detailed_size
hypertable_approximate_detailed_size
hypertable_index_size
chunks_detailed_size
Hypercore
Continuous aggregates
Data retention
Jobs and automation
UUIDv7 functions
Hyperfunctions
Informational views
Service configuration
Administration Functions
API Reference Tag Overview
Tiger Cloud REST API
Glossary
Compression (Old API, replaced by Hypercore)
Distributed hypertables (Sunsetted v2.14.x)
Import and sync
Integrate AI with Tiger Data
Other deployment options
Find a docs page
TimescaleDB API referenceHypertables and chunks

show_tablespaces()

Tiger Cloud: Performance, Scale, Enterprise, Free

Self-hosted products

MST

Show the tablespaces attached to a hypertable.

Samples

SELECT * FROM show_tablespaces('conditions');
show_tablespaces
------------------
disk1
disk2

Required arguments

NameTypeDescription
hypertableREGCLASSHypertable to show attached tablespaces for.

Keywords

tablespaceshypertables

Found an issue on this page?Report an issue or Edit this page in GitHub.

Previousdetach_tablespacesNextset_chunk_time_interval

Related Content

show_chunks()
Show the chunks belonging to a hypertable
move_chunk()
Move a chunk and its indexes to a different tablespace
attach_tablespace()
Attach a tablespace to a hypertable
detach_tablespace()
Detach a tablespace from a hypertable
detach_tablespaces()
Detach all tablespaces from a hypertable
Hypertables and chunks
TigerAPI reference for dealing with hypertables and chunks. Includes all SQL functions and views related to managing hypertables, chunks, dimensions, tablespaces, and indexing