Timescale Extension not Available

[nicky]

Render’s documentation says that Timescale’s Apache license version is available in PostgreSQL, but it is not available in our Render Postgres preview instances.

Is this a bug or the documentation is wrong?

Relevant docs:

Supported PostgreSQL Extensions – Render Docs

[nicky]

Actually it seems like the extension is there. This works:

CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;

But I was checking with this query and it was not returning anything:

SELECT * FROM pg_extension WHERE extname = 'timescaledb';

My bad, this one is better:

SELECT * FROM pg_available_extensions WHERE name = 'timescaledb';