How to display full query in logs

Поиск
Список
Период
Сортировка
От Campbell, Lance
Тема How to display full query in logs
Дата
Msg-id B75CD08C73BD3543B97E4EF3964B7D701F108057@CITESMBX1.ad.uillinois.edu
обсуждение исходный текст
Ответы Re: How to display full query in logs  ("Campbell, Lance" <lance@illinois.edu>)
Список pgadmin-support
<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> 

В списке pgadmin-support по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: how to build pgadmin3 when wxgtk was built with --disable-unicode ?
Следующее
От: "Campbell, Lance"
Дата:
Сообщение: Re: How to display full query in logs