Node.js PostgreSQL single quote issue with prepared query
<p>I have an issue with an INSERT query in PostgreSQL and Node.js</p>

<p>It looks like values containing a single quote like "L'Ange" isn't passing through the query : </p>

<pre><code>connection.query('insert into my_table (name) select $1', {name : "L'ange"}, function ...
</code></pre>

<p>Error </p>

<blockquote>
  <p>[error: syntax error at or near "Ange"]</p>
</blockquote>

<p>Any idea ? </p>

<p>I already tried, various sql escapes, even the npm module "pg-escape", nothing works...
Thanks !</p>