Postgresql Replace JSON Object With Key Value Within JSONB With Unknown Index Number
I have a jsonb column within my table that looks like this:
How to use value of another field as the key in a jsonb query in postgresql
I have a department table that has a jsonb field that give the hours of operation that looks like: