Timescaledb: how to check created hypertable?

Created on 8 Aug 2018 · 5Comments · Source: timescale/timescaledb

You have successfully created a hypertable , as per the corresponding document ( https://docs.timescale.com/v0.10/using-timescaledb/hypertables#create) . But I'd like to know how to make sure we've created that hypervisor.

question

Source

100milliongold

Most helpful comment

Hi there. If you run the following query in psql, select * from _timescaledb_catalog.hypertable, then you should see the hypertable that you just created in the result list.

amytai on 8 Aug 2018

👍10

All 5 comments

Hi there. If you run the following query in psql, select * from _timescaledb_catalog.hypertable, then you should see the hypertable that you just created in the result list.

amytai on 8 Aug 2018

👍10

Thank you.

100milliongold on 13 Aug 2018

Is this still the way to go?

Looks like this dates back to v0.10. Latest doc recommend SELECT * FROM timescaledb_information.hypertables;.

I'm using Timescale 2 and the command here works while the one from the docs doesn't (timescaledb_information.hypertable table doesn't exist), so I'm a bit confused.

Related SO question: https://stackoverflow.com/questions/67089109/.