Re: Getting value of bind variables

On 8/19/2011 9:01 AM, Adrian Klaver wrote:
> On Friday, August 19, 2011 6:55:39 am Andy Colson wrote:
>>> As of now, I am trying with logging level set to debug5 in
>>> postgresql.conf for all logging options. But what is the 'correct'
>>> approach?
>>>
>>> Regards,
>>> Jayadevan
>>
>> Not sure what the exact setting is, try:
>>
>> log_statement = 'all'
>>
>> I've never set the log_min_messages or log_min_error_statement, and I'm
>> pretty sure I've seen values in my logs.
>
> If I remember correctly this is version specific, though I cannot remember what
> version the actual variables where made visible:(
>

Ah, yeah, you are probably right.

I can confirm in PG 9, with just

 >> log_statement = 'all'

I see things like:

DETAIL:  parameters: $1 = '%oak%'

in my log.

-Andy