skip to Main Content

Select hierarchical JSON as table in PostgreSQL

I'm trying to select this hierarchical JSON as a table in PostgreSQL The JSON script: '{"NODES":[{"DESC_D":"fam","SEQ":"1","ID":"2304500","NODES":[{"DESC_D":"test 1","SEQ":"2.1","ID":"5214","NODES":[{"DESC_D":"test 1.1","SEQ":"3.1","ID":"999"}]},{"DESC_D":"test 2","SEQ":"2.2","ID":"74542"}]}]}' The output I'm trying to get (click this link) This is a solution a friend wrote. It does the required but…

VIEW QUESTION
Back To Top
Search