title: How do I remove single quotes from a table in postgresql?
body: <p>I searched around quite a bit, it would be great if someone could link me to a solution or answer my query.
  The thing is I have a postgresql table that contains a lot of single quotes and I cant figure out how to get rid of them, because obviously this</p>
  
  <pre><code>  update tablename set fieldname= NULL where fieldname=' ; 
  </code></pre>
  
  <p>wont work.</p>