title: Update multiple values in a jsonb data in PostgreSQL
body: <p>I need to update a jsonb data(column->users) in my table 'settings'
   My jsonb data is like </p>
  
  <pre><code>'{
      "Email": "aaaa",
      "UserId": "49",
      "Created": "11/13/2016",
      "EntityId": "1",
      "IsActive": "False",
      "Modified": "11/13/2016",
      "Username": "aa"
  }' 
  </code></pre>
  
  <p>In this json string I need to update Email,IsActive,Username together. 
  I tried the below update query,its working fine. But that is for a single value updation.</p>
  
  <pre><code>UPDATE settings 
  SET users = jsonb_set(users, '{Email}', '"aa"') 
  WHERE users @&gt; '{"UserId":"49"}';
  </code></pre>
  
  <p>How to update for multiple value updation? I am using postgres 9.5.</p>