title: Replace unicode characters in PostgreSQL
body: <p>Is it possible to replace all the occurrences of a given character (expressed in unicode) with another character (expressed in unicode) in a varchar field in PostgreSQL?</p>
  
  <p>I tried something like this:</p>
  
  <pre><code>UPDATE mytable 
  SET myfield = regexp_replace(myfield, '\u0050', '\u0060', 'g')
  </code></pre>
  
  <p>But it seems that it really writes the string '\u0060' in the field and not the character corresponding to that code.</p>