title: POSTGRESQL Dollar Quotes in Where Clause
body: <p>For people who tried or needed a solution to escape every special character (even $) in a WHERE CLAUSE in POSTGRESQL, here is how it should be use</p>
  <blockquote>
  <p>the documentation can be somehow hard to understand, and there is no proper example of it so here is mine</p>
  </blockquote>
  <p>e.g : if you want to make a request looking as</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT
      *
  FROM
      &lt;TableName&gt; 
  WHERE
      &lt;ColumnName&gt; = 'string with ' character';
  </code></pre>
  <p>it will throw an error cause &quot;character'&quot; is outside the string</p>