Discussion:
How to display full query in logs
(too old to reply)
Campbell, Lance
2013-01-08 15:50:21 UTC
Permalink
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/>
Tom Lane
2013-01-08 16:29:01 UTC
Permalink
Post by Campbell, Lance
UPDATE abc.table set def=$1 WHERE id=$2
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-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Loading...