Postgresql escape single quote in where clause
<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>