title: How can I remove special characters from my column
body: <p>Have a table with 2 columns. Column a has records with non alpha such as:</p>
  <pre><code>aaa)
  aab(
  aac#
  123!
  </code></pre>
  <p>column b is blank</p>
  <p>Need a PostgreSQL function that can strip all non alpha characters and insert the changed values to column b.</p>
  <p>So that the end result is</p>
  <p>columna</p>
  <pre><code>aaa)
  aab(
  aac#
  123!
  </code></pre>
  <p>columnb</p>
  <pre><code>aaa
  aab
  aac
  123
  </code></pre>
  <p>I want to be able to call function with table name. Thanks for any help</p>