[
{"id":"1","value":"48768"},
{"id":"2","value" ["String","http:someurl]},
{"id":"5","value":"somevalue"},
{"id":"6","value":""},
{"id":"8","value":"Op-Ed"},
{"id":"9","value":"8111,13498,15408"},
{"id":"10","value":"30"},
{"id":"11","value":"This is the target string"}
]

SELECT extra_fields->>"$[*].id"  FROM esqt7_k2_items;

SELECT extra_fields->>"$[*].value"  FROM esqt7_k2_items;

SELECT extra_fields->>"$[2].value"  FROM esqt7_k2_items;