Question: I am using Postgressql. I have a column with nested json data as follows - ( one row shown ) : [ { Province

I am using Postgressql. I have a column with nested json data as follows -(one row shown): [{"Province":"BALOCHISTAN","District":"NSIRABAD","Tehsil":"DM JAMALI","Uc":"QUBA SHER KHAN SHARQI B","AIC":"Abdul Qadir","Team":"1","DeploymentStatus":"Deployed","IMEI":"350876260557037","PID":"Z04211","Type":"First Last Ping","ReportingStart":"2024-02-2706:32:13","ReportingEnd":"2024-02-2706:33:13","ExpectedPings":1,"ActualPings":1,"ReportingStatus":"Reporting","Date":"2024-02-27","LastUpdatedAt":"2024-02-2723:55:52"},{"Province":"BALOCHISTAN","District":"NSIRABAD","Tehsil":"DM JAMALI","Uc":"QUBA SHER KHAN SHARQI B","AIC":"Mitha Khan ","Team":"4","DeploymentStatus":"Deployed","IMEI":"350876260553762","PID":"Z04209","Type":"First Last Ping","ReportingStart":"2024-02-2707:49:07","ReportingEnd":"2024-02-2712:21:07","ExpectedPings":272,"ActualPings":272,"ReportingStatus":"Reporting","Date":"2024-02-27","LastUpdatedAt":"2024-02-2723:55:52"},{"Province":"BALOCHISTAN","District":"NSIRABAD","Tehsil":"DM JAMALI","Uc":"QUBA SHER KHAN SHARQI B","AIC":"Abdul Qadir","Team":"4","DeploymentStatus":"Deployed","IMEI":"350876260556773","PID":"Z04214","Type":"First Last Ping","ReportingStart":"2024-02-2706:32:50","ReportingEnd":"2024-02-2706:32:50","ExpectedPings":0,"ActualPings":0,"ReportingStatus":"Reporting","Date":"2024-02-27","LastUpdatedAt":"2024-02-2723:55:52"}]-------------------- I want to extract IMEI,ReportingStart,ReportingEnd as seperate columns.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!