DEV Community

loading...

how to retrieve information about hypertables timescaledb_information.hypertable

abigoroth profile image Ahmad Ya'kob Ubaidullah ・1 min read

TimescaleDB maintains metadata about hypertables and provides views to query for the metadata. Views are located in schema timescaledb_information and information about hypertables can be retrieved from timescaledb_information.hypertable.

For example:

SELECT * FROM timescaledb_information.hypertable WHERE table_name = 'data';

This API doc contains more information and examples.

Note that the…

Discussion

pic
Editor guide