how to get timescaledb version of the database
Turns out, that my assumption was wrong: SELECT extversion FROM pg_extension where extname=”timescaledb”; returns the version of the currently connected database. Here is how we can find out the versions: SELECT default_version, installed_version FROM pg_available_extensions where name=”timescaledb”; default_version: is the version installed in the PostgreSQL server instance installed_version: is the version that the current database … Read more