Re: Getting value of bind variables - Mailing list pgsql-general

From Andy Colson
Subject Re: Getting value of bind variables
Date
Msg-id 4E4E6D64.2090808@squeakycode.net
Whole thread Raw
In response to Re: Getting value of bind variables  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Getting value of bind variables
Next
From: Adrian Klaver
Date:
Subject: Re: Dump a database excluding one table DATA?