pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
How to display full query in logs 2+ messages / 2 participants [nested] [flat]
* How to display full query in logs @ 2013-01-08 15:50 Campbell, Lance <lance@illinois.edu> 2013-01-08 16:29 ` Re: How to display full query in logs Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Campbell, Lance @ 2013-01-08 15:50 UTC (permalink / raw) To: pgsql-admin 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 [University of Illinois at Urbana-Champaign logo]<http://illinois.edu/; Attachments:^ permalink raw reply [nested|flat] 2+ messages in threadimage001.png (image/png, 1.4K) download
view image
* Re: How to display full query in logs 2013-01-08 15:50 How to display full query in logs Campbell, Lance <lance@illinois.edu> @ 2013-01-08 16:29 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2013-01-08 16:29 UTC (permalink / raw) To: Campbell, Lance <lance@illinois.edu>; +Cc: pgsql-admin "Campbell, Lance" <lance@illinois.edu> writes: > 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 It doesn't work that way. What you should be seeing, though, is that the value of each parameter is included in a DETAIL line just after the statement text. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2013-01-08 16:29 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2013-01-08 15:50 How to display full query in logs Campbell, Lance <lance@illinois.edu> 2013-01-08 16:29 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox