By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| jsonb_pretty |
|---|
| [ { "sensorid": 1, "jsonb_build_object": { "data": [ { "timestamp": "8:22pm", "temperature": "22C" }, { "timestamp": "8:31pm", "temperature": "28C" } ] } }, { "sensorid": 2, "jsonb_build_object": { "data": [ { "timestamp": "8:23pm", "temperature": "21C" }, { "timestamp": "8:26pm", "temperature": "27C" }, { "timestamp": "8:28pm", "temperature": "19C" } ] } }, { "sensorid": 3, "jsonb_build_object": { "data": [ { "timestamp": "8:25pm", "temperature": "24C" } ] } } ] |