I have data structure like:
- id bigint
- articles 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
