Postgres combine jsonb with same keys

Viewed 31

Need to combine jsonb having same key in jsonb. I have following Table:

 id |                         permissions                          
------+-------------------------------------------------------------- 
 id1 | {"users": {}, "groups": {"ReadKey": ["gdv"]}, "clients": {}} 
 id1 | {"users": {}, "groups": {"ReadKey": ["jahanvi"]}, "clients": {}} 
 id1 | {"users": {}, "groups": {"ReadKey": ["mandeep","gdv"]}, "clients": {}} 
 id2 | {"users": {}, "groups": {"ExportKey": ["test1","test2"]}, "clients": {}} 
 id2 | {"users": {}, "groups": {"ExportKey": ["test3","test4"]}, "clients": {}} 

Need below output:

id1 | {"users": {}, "groups": {"ReadKey": ["gdv","jahanvi","mandeep","gdv"]}, "clients": {}} 
id2 | {"users": {}, "groups": {"ExportKey": ["test1","test2","test3","test4"]}, "clients": {}} 
0 Answers
Related