How to convert raw json data to valid json format

[muralam]

Hi ,

i have a postgress table where column data type is JSON, i am getting data in this column, how can i convert this column data into readable json format so that i can extract the coulmn data into multiple fields

Urgent help is needed

Regards,

Murala

[iamabhishek]

How does your data looks like and what is your expected output?