title: hstore value with single quote
body: <p>I asked similar question here for: hstore value with space. And get solved by user: Clodoaldo Neto. Now I have come across next case with string containing single quote.</p>
  
  <pre><code>SELECT 'k=&gt;"name", v=&gt;"St. Xavier's Academy"'::hstore;
  </code></pre>
  
  <p>I tried it by using dollar-quoted string constant by reading <a href="http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS" rel="nofollow">http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS</a></p>
  
  <pre><code>SELECT 'k=&gt;"name", v=&gt;$$St. Xavier's Academy$$'::hstore;
  </code></pre>
  
  <p>But I couldn't get it right.</p>
  
  <p>How to make postgresql hstore using strings containing single quote?
  It seems like there are more such exceptions possible for this query. How to address them all at once? </p>