Обсуждение: How to display full query in logs

<div class="WordSection1"><p class="MsoNormal">PostgreSQL 9.2.2<p class="MsoNormal">Is there a configuration parameter
inPostgreSQL that will allow a full query to be displayed in the log file?<p class="MsoNormal"> <p
class="MsoNormal">WhatI see:<p class="MsoNormal">UPDATE abc.table set def=$1 WHERE id=$2<p class="MsoNormal"> <p
class="MsoNormal">WhatI want to see:<p class="MsoNormal">UPDATE abc.table set def=’hi bob’ WHERE id=12<p
class="MsoNormal"> <pclass="MsoNormal">Thanks,<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="25" id="Picture_x0020_1" src="cid:image001.png@01CDED84.ED2037B0"
width="150"/></span></a><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:blue"></span><p
class="MsoNormal"> <pclass="MsoNormal"> </div>