| From: | Bjørn T Johansen <btj(at)havleik(dot)no> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Logging of sql statements? |
| Date: | 2006-03-23 16:09:52 |
| Message-ID: | 20060323170952.7e398506@pennywise.havleik.no |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 23 Mar 2006 14:25:52 +0100
"A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> wrote:
> am 23.03.2006, um 14:07:11 +0100 mailte Bjørn T Johansen folgendes:
> > Is it possible to log the actual statement that the server runs? At the moment, the statement that is
> > logged, is logged using ? for parameters; I would like to log the statement after the parameters have been
> > substituted, isn't this possible in 8.1.x? (used to work in 7.x.x)
>
> Yes, this is possible.
>
> Set in your postgresql.conf:
>
> log_statement = all
>
> Since 8.0 oder 8.1, there you can see parameters in prepared statements.
>
>
>
> HTH, Andreas
This is what I am already using and it doesn't work...
BTJ
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2006-03-23 16:17:38 | Re: Logging of sql statements? |
| Previous Message | JP Glutting | 2006-03-23 15:37:48 | Re: ERROR: could not convert UTF8 character to ISO8859-1 |