<div class="WordSection1"><p class="MsoNormal">PostgreSQL 9.2.2<p class="MsoNormal">pgAdmin 1.16.1<p
class="MsoNormal">pgAdmin> Tools > Server Status<p class="MsoNormal"> <p class="MsoNormal">When viewing the
ServerStatus window I notice that my queries look like this:<p class="MsoNormal"> <p class="MsoNormal">SELECT * FROM
tablexWHERE id=$1<p class="MsoNormal"> <p class="MsoNormal">How can I display the full query without the $1? <p
class="MsoNormal"> <pclass="MsoNormal">Example of what I would like to see:<p class="MsoNormal"> <p
class="MsoNormal">SELECT* FROM tablex where id=75<p class="MsoNormal"> <p class="MsoNormal">I would assume this is some
kindof setting within the PostgreSQL database log configuration. But I am at a loss on what I need to set in order to
havethe parameters populated.<p class="MsoNormal"> <p class="MsoNormal">Thanks for your help. This is an amazing
tool. I used it just today to identify an issue. Because I could not see the $1 value I was only able to solve part of
theissue. If I could see the full query that would allow me to zero in directly to the issue.<p class="MsoNormal"> <p
class="MsoNormal">Thanksagain for the great tool,<p class="MsoNormal"> <p class="MsoNormal">Lance Campbell<p
class="MsoNormal">SoftwareArchitect<p class="MsoNormal">Web Services at Public Affairs<p
class="MsoNormal">217-333-0382<pclass="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><a
href="http://illinois.edu/"><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:blue;text-decoration:none"><imgalt="University of
Illinoisat Urbana-Champaign logo" border="0" height="33" id="Picture_x0020_1" src="cid:image003.png@01CDE99A.B35EEAF0"
width="195"/></span></a><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:blue"></span><p
class="MsoNormal"> <pclass="MsoNormal"> </div>