Postgres Pro
Downloads
Home   >   mailing lists

Re: How to display full query in logs - Mailing list pgsql-admin

From Tom Lane
Subject Re: How to display full query in logs
Date
Msg-id 9187.1357662541@sss.pgh.pa.us
Whole thread Raw
In response to How to display full query in logs  ("Campbell, Lance" <lance@illinois.edu>)
List pgsql-admin
Tree view 
"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

pgsql-admin by date:

Previous
From: "Campbell, Lance"
Date:
Subject: How to display full query in logs
Next
From: "Benjamin Krajmalnik"
Date:
Subject: General queston on getting rid of unused WAL files