title: How to update jsonb string with PostgreSQL?
body: <p>I'm using PostgreSQL 9.4.5. I'd like to <strong>update</strong> a <code>jsonb</code> column.</p>
  
  <p>My table is structured this way:</p>
  
  <pre><code>CREATE TABLE my_table (
    gid    serial PRIMARY KEY,
    "data" jsonb
  );
  </code></pre>
  
  <p>JSON strings are like this:</p>
  
  <pre><code>{"files": [], "ident": {"id": 1, "country": null, "type ": "20"}}
  </code></pre>
  
  <p>The following SQL doesn't do the job (syntax error - SQL state = 42601):</p>
  
  <pre><code>UPDATE my_table SET "data" -&gt; 'ident' -&gt; 'country' = 'Belgium';
  </code></pre>
  
  <p>Is there a way to achieve that?</p>