title: POSTGRESQL: remove all characters before a specific character
body: <p>I have values like <code>6864#21</code>, <code>1a2b#3598</code> in my database.  I'm trying to extract just the portion before and after the #, so I would get something like</p>
  
  <pre>
  col1  | col2
  -----------
  6864  | 21
  1a2b  | 3598
  </pre>
  
  <p>I tried </p>
  
  <pre><code>REPLACE('123#89', '%#', '')
  </code></pre>
  
  <p>but that just resulted in 123#89.  Does anyone know a way I can do this?</p>