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": {}}