title: Escape tab character PostgreSQL
body: <p>I have got a varchar field and I am migrating this field to a JSON type field. Some of the data has got tabulator, and when trying to insert to the new JSON field it tells me this error: DETAIL:  Character with value 0x09 must be escaped.</p>
  
  <p>I am trying to escape and delete tabulator characters like this but no succes:</p>
  
  <pre><code>v_text:=REPLACE(text, '\x09', '');
  </code></pre>
  
  <p>or</p>
  
  <pre><code> v_text:=REPLACE(text, '0x09', '');
  </code></pre>
  
  <p>How can I delete all tabulator characters from a text?
  Thanks</p>