Hi
I have a nested field that I cannot extract
Using this query:
SELECT ("public"."TradeFill"."trade_fee"#>> '{flat_fees}'::text[])::text AS "trade_fee → flat_fees"
FROM "public"."TradeFill"
LIMIT 1048575
it returns
trade_fee → flat_fees
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"token": "USDT", "amount": "0.02734272000000000091279872549421270377933979034423828125"}]
[]
[{"token": "USDT", "amount": "0.00783552000000000033186342562885329243727028369903564453125"}]
[]
[{"token": "USDT", "amount": "0.000074040000000000002621132477731435983514529652893543243408203125"}]
[{"token": "USDT", "amount": "0.00557151000000000000411670697531008045189082622528076171875"}]
Does anybody knows how can I then split the token and amount fields into additional columns so that if the json is not empty, I can populate the values into two columns?
Thanks in advance for your support