I have JSON data as follows:
"group_nw4qu40":[
{"group_nw4qu40/Special_Characteristics":"11"},
{"group_nw4qu40/Special_Characteristics":"0"},
{"group_nw4qu40/Special_Characteristics":"0"},
{"group_nw4qu40/Special_Characteristics":"1"},
{"group_nw4qu40/Special_Characteristics":"1"}]
My task is to Traverse though the Array within an array to fetch the "Special_Characteristic" of each individual member and create a table having these values in Multiple Rows under same column.
I tried using this query but, it fetches me values in multiple columns which is incorrect for me.
select id AS id, (json->'group_nw4qu40'->>0)::json->>'group_nw4qu40/Special_Characteristics' AS value_of_special_characteristic from public.logger_instance where id = 5215
Please help me get these values in multiple Rows under same column.