title: Update jsonb object in postgres
body: <p>One of my column is jsonb and have value in the format. The value of a single row of column is below.</p>
  
  <pre><code>{
      "835": {
          "cost": 0, 
          "name": "FACEBOOK_FB1_6JAN2020", 
          "email": "test.user@silverpush.co", 
          "views": 0, 
          "clicks": 0, 
          "impressions": 0, 
          "campaign_state": "paused", 
          "processed":"in_progress", 
          "modes":["obj1","obj2"]
      }, 
      "876": {
          "cost": 0, 
          "name": "MARVEL_BLACK_WIDOW_4DEC2019", 
          "email": "test.user@silverpush.co", 
          "views": 0, 
          "clicks": 0, 
          "impressions": 0, 
          "campaign_state": "paused", 
          "processed":"in_progress", 
          "modes":["obj1","obj2"]
      }
  }
  </code></pre>
  
  <p>I want to update campaign_info(column name) column's the inner key "processed"  and "models" of the campaign_id is "876". </p>
  
  <p>I have tried this query:</p>
  
  <pre><code>update safe_vid_info 
  set campaign_info -&gt; '835' --&gt; 'processed'='completed' 
  where cid = 'kiywgh'; 
  </code></pre>
  
  <p>But it didn't work.</p>
  
  <p>Any help is appreciated. Thanks.</p>