Skip to content
TimescaleDB - Timeseries database for PostgreSQL
  • Timescale.com
  • Try for free
Get started
Use Timescale
Tutorials
Code quick starts
API Reference
Hypertables & chunks
create_hypertable
show_chunks
drop_chunks
reorder_chunk
move_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
create_index (transaction per chunk)
hypertable_size
hypertable_detailed_size
hypertable_index_size
chunks_detailed_size
Distributed hypertables
Compression
Continuous aggregates
Data retention
Actions and automation
Hyperfunctions
Informational views
Configuration
Administration Functions
API Reference Tag Overview
Other deployment options
About Timescale
Find a docs page
TimescaleDB API referenceHypertables and chunks

show_tablespaces()

Show the tablespaces attached to a hypertable.

Required arguments

NameTypeDescription
hypertableREGCLASSHypertable to show attached tablespaces for.

Sample usage

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

Keywords

tablespaceshypertables

Found an issue on this page?

Report an issue!
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
timescaledb_information.chunks
Get metadata about hypertable chunks