postgresql – como recorrer un arreglo en postgres

asi es como se ve como debo desempaquetarlo???

“json_data”:[{“id”:”8″,”value”:”3″},{“id”:”9″,”value”:”2″},{“id”:”10″,”value”:”3″},{“id”:”11″,”value”:”3″},{“id”:”30″,”value”:”3″},{“id”:”31″,”value”:”3″},{“id”:”32″,”value”:”3″},{“id”:”33″,”value”:”3″},{“id”:”34″,”value”:”3″},{“id”:”35″,”value”:”2″},{“id”:”21″,”value”:”2″},{“id”:”22″,”value”:”3″},{“id”:”23″,”value”:”3″},{“id”:”25″,”value”:”2″},{“id”:”26″,”value”:”3″},{“id”:”27″,”value”:”3″},{“id”:”28″,”value”:”2″},{“id”:”29″,”value”:”3″},{“id”:”63″,”value”:”2″},{“id”:”64″,”value”:”3″},{“id”:”65″,”value”:”3″},{“id”:”66″,”value”:”3″},{“id”:”67″,”value”:”3″},{“id”:”68″,”value”:”3″},{“id”:”69″,”value”:”2″},{“id”:”70″,”value”:”2″},{“id”:”71″,”value”:”2″},{“id”:”80″,”value”:”3″},{“id”:”72″,”value”:”2″},{“id”:”73″,”value”:”2″},{“id”:”74″,”value”:”2″},{“id”:”75″,”value”:”2″},{“id”:”76″,”value”:”3″},{“id”:”77″,”value”:”3″},{“id”:”78″,”value”:”3″},{“id”:”79″,”value”:”3″},{“id”:”55″,”value”:”2″},{“id”:”56″,”value”:”3″},{“id”:”57″,”value”:”2″},{“id”:”58″,”value”:”3″},{“id”:”59″,”value”:”2″},{“id”:”60″,”value”:”3″},{“id”:”61″,”value”:”3″},{“id”:”62″,”value”:”2″},{“id”:”49″,”value”:”3″},{“id”:”50″,”value”:”2″},{“id”:”51″,”value”:”2″},{“id”:”52″,”value”:”2″},{“id”:”53″,”value”:”2″},{“id”:”54″,”value”:”3″},{“id”:”41″,”value”:”2″},{“id”:”42″,”value”:”2″},{“id”:”43″,”value”:”2″},{“id”:”44″,”value”:”3″},{“id”:”45″,”value”:”3″},{“id”:”46″,”value”:”3″},{“id”:”47″,”value”:”3″},{“id”:”48″,”value”:”3″},{“id”:”81″,”value”:”3″},{“id”:”82″,”value”:”3″},{“id”:”83″,”value”:”3″},{“id”:”86″,”value”:”3″},{“id”:”87″,”value”:”3″},{“id”:”88″,”value”:”2″},{“id”:”89″,”value”:”2″},{“id”:”90″,”value”:”2″},{“id”:”91″,”value”:”2″},{“id”:”92″,”value”:”2″},{“id”:”36″,”value”:”2″},{“id”:”37″,”value”:”2″},{“id”:”38″,”value”:”2″},{“id”:”39″,”value”:”2″},{“id”:”40″,”value”:”3″}]