title: How can I update my json field in postgreSQL?
body: <p>I have the following table myTable :</p>
  <pre><code>id info
  1  {'email': 'bob@bob.com', 'country': 'USA'}
  2  {'email': 'test@test.com', 'country': 'DE'}
  </code></pre>
  <p>I would like to update the field country like this :</p>
  <pre><code>id info
  1  {'email': 'bob@bob.com', 'country': 'country1'}
  2  {'email': 'test@test.com', 'country': 'country2'}
  </code></pre>
  <p>I tried this :</p>
  <pre><code>UPDATE myTable set info-&gt;country : format('country%s', id);
  </code></pre>
  <p>but it does not work</p>
  <p>Could you help me please ?</p>
  <p>Thank you very much !</p>