Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Create Table ss (timestamp text, values json);

CREATE TABLE


Insert Into ss (timestamp, values)
Values ('xxxx', '[{"d_st":1601,"d_val":2.731},{"d_st":1602,"d_val":0.465},{"d_st":1603,"d_val":0.422},{"d_st":1604,"d_val":2.803},{"d_st":1605,"d_val":2.771},{"d_st":1606,"d_val":260.352}]')

INSERT 0 1


Select ss.timestamp, x.d_st, x.d_val
From ss Cross Join Lateral json_to_recordset(ss.values) As x(d_st int, d_val numeric)


timestamp
d_st
d_val


xxxx
1601
2.731

xxxx
1602
0.465

xxxx
1603
0.422

xxxx
1604
2.803

xxxx
1605
2.771

xxxx
1606
260.352



SELECT 6

timestamp	d_st	d_val
xxxx	1601	2.731
xxxx	1602	0.465
xxxx	1603	0.422
xxxx	1604	2.803
xxxx	1605	2.771
xxxx	1606	260.352