Thread: 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>
I sent this to the wrong mailing list. Sorry.
From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Campbell, Lance
Sent: Tuesday, January 08, 2013 9:46 AM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] How to display full query in logs
PostgreSQL 9.2.2
Is there a configuration parameter in PostgreSQL that will allow a full query to be displayed in the log file?
What I see:
UPDATE abc.table set def=$1 WHERE id=$2
What I want to see:
UPDATE abc.table set def=’hi bob’ WHERE id=12
Thanks,
Lance Campbell
Software Architect
Web Services at Public Affairs
217-333-0382