Hi, I have a Postgres/timescale datasource, but the data itself is in a jsonb column (as eachj device has a different set of sensors). Is there any syntax trick to access the json values. In pure postgres I can do stuff like select cast(elements->>‘temperature’ AS INTEGER) from datapoints … Any way…

Jsonb column access

tpedoussaut March 12, 2019, 4:14pm 2

Just to auto-answer, cast(elements->>‘temperature’ AS float) works fine in the end.

Topic		Replies	Views
How to visualise timescaledb metrics stored in an SQL jsonb datatype Grafana	2	541	July 14, 2022
Dynamically read JSON fields from PostgreSQL Time Series Panel plugins	4	1677	April 24, 2024
Display json from postgres database Time Series Panel postgres	0	605	July 26, 2021
Query with postgresql with json data PostgreSQL	2	499	June 23, 2025
Extract Field gives blank chart for JSON data Dashboards json	2	949	October 4, 2023