how to retrieve information about hypertables timescaledb_information.hypertable

answer re: How to determine if a table has Timescale enabled and on which columns?

Oct 16 '19

3

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…

Open Full Answer