title: How to add parameter values to pgadmin sql query?
body: <p>In pgadmin3, I would like to use parameterized queries (to faster debugging, just copy &amp; paste the query from my php file). But I haven't found an option to add the values of the <code>$1</code>, <code>$2</code>... parameters. Is it possible?</p>
  
  <p>This is the query I'm building in a loop, following the suggestion for NULL testing from <a href="https://stackoverflow.com/a/17355733/1086511">here</a>:</p>
  
  <pre><code>SELECT EXISTS(SELECT 1
                FROM tax
                WHERE (addby=$1 or addby&lt;&gt;$1)
                      AND (adddate=$2 or adddate&lt;&gt;$2)
                      AND ($3 IS NULL AND nome IS NULL OR nome=$3)
                      AND ($4 IS NULL AND rank IS NULL OR rank=$4)
                      AND ($5 IS NULL AND pai IS NULL OR pai=$5)
                      AND ($6 IS NULL AND valido IS NULL OR valido=$6)
                      AND ($7 IS NULL AND sinonvalid IS NULL OR sinonvalid=$7)
                      AND ($8 IS NULL AND espec IS NULL OR espec=$8)
                      AND ($9 IS NULL AND public IS NULL OR public=$9)
         );
  </code></pre>
  
  <p>Notice that substitute all parameters by hand is tedious, error-prone and probably (I hope) unnecessary.</p>
  
  <p>Thanks in advance.</p>