title: regex to replace backslash and single quote with single quote using postgres regexp_replace()
body: <p>Just as the title states, I'm not the best w/ regex, so can anyone provide the appropriate regex for the following:</p>
  
  <pre><code>UPDATE table SET column = REGEXP_REPLACE(column, {regex}, '''');
  </code></pre>
  
  <p>Basically, I'd like to replace any instances of backslashes (<code>\</code>) followed by <em>one or more</em> single quotes with one single quote.</p>
  
  <p>So, the string <code>Hello World\'s</code> or <code>Hello World\'''''s</code> should become <code>Hello World's</code>, but not <code>Hello World\s</code>.</p>