title: PostgreSQL UPDATE substring replacement
body: <p>I have a few rows in a test database where there are dollar signs prefixed to the value. I want to <code>UPDATE</code> the values in the <code>name</code> row of the <code>test1</code> table however when I threw the following query together it emptied the six rows of data in the <code>name</code> column...</p>
  
  <pre><code>UPDATE test1 SET name=overlay('$' placing '' from 1 for 1);
  </code></pre>
  
  <p>So "$user" became "" when I intended for that column/row value to become "user".</p>
  
  <p>How do I combine UPDATE and a substr replacement without deleting any of the other data?</p>
  
  <p>If there isn't a dollar sign I want the row to remain untouched.</p>
  
  <p>The dollar sign only occurs as the first character when it does occur.</p>