DEV Community


how to retrieve information about hypertables timescaledb_information.hypertable

Ahmad Ya'kob Ubaidullah
hi, im an experienced Ruby on Rails developer. But I need to do some CSS for now. I'm in big trouble now. :D
・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 (0)