Re: How to display full query in logs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Campbell, Lance" <lance(at)illinois(dot)edu>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How to display full query in logs
Date: 2013-01-08 16:29:01
Message-ID: 9187.1357662541@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Campbell, Lance" <lance(at)illinois(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Benjamin Krajmalnik 2013-01-09 01:55:33 General queston on getting rid of unused WAL files
Previous Message Campbell, Lance 2013-01-08 15:50:21 How to display full query in logs