I have data structure like:
id bigintarticles jsonb
Example:
id: 1,
articles: {
"1": {
"title": "foo"
},
"2": {
"title": "bar"
}
}
I want to change field name of title (for example articleTitle). Is there any easy way to do that ?
Edit: I can do that with string replace, but can I do that operating on jsonb? Like using jsonb_set() ?
UPDATE person
SET articles = replace(articles::TEXT,'"title":','"articleTitle":')::jsonb