title: Postgresql escape single quote in where clause
body: <p>so I am trying to run a script like this one: </p>
  
  <pre><code>select id
  from owner 
  where owner.name = "john's"
  </code></pre>
  
  <p>and I am getting this error: <code>ERROR: column "john's" does not exist</code>.</p>
  
  <p>Also I tried like this: <code>where owner.name = 'john\'s'</code>, but it dit not work</p>
  
  <p>Anyone knows how I can run a query like this one?</p>