title: How to remove non-breaking spaces from a column in Postgres
body: <p>Trying to remove a non-breaking space from a field without any success. I've tried </p>
  
  <pre><code>execute &lt;&lt;-SQL
    UPDATE customers
    SET name = TRIM (name)
  SQL
  </code></pre>
  
  <p>but this removes only spaces. It's similar question as <a href="https://stackoverflow.com/questions/15214848/how-do-i-remove-non-breaking-spaces-from-a-column-in-sql-server?utm_medium=organic&amp;utm_source=google_rich_qa&amp;utm_campaign=google_rich_qa%22this%22">this</a> but I need it for Postgres (Postgres complains <code>syntax error at or near "x00A0"</code>) and also I need only trimming i.e it has to remove only at the beginning and at the end of the text.</p>
  
  <p>Thanks</p>