Re: change format of logging statements? - Mailing list pgsql-general

From Matthew Hixson
Subject Re: change format of logging statements?
Date
Msg-id BB3CF982-D896-4859-BB7E-58117C57169B@poindextrose.org
Whole thread Raw
In response to Re: change format of logging statements?  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: change format of logging statements?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
With 8.2.4 is it possible to get Postgres to log incoming SQL
statements the same as they look when written?  Instead of:

DEBUG: insert into foo (name) values ($1);
DETAIL: parameters: $1 = 'stan'

I'd like to see:

DEBUG: insert into foo (name) values ('stan');

This would be extremely helpful when debugging complex Hibernate
generated queries.  I could just copy&paste the query into a psql
session and begin playing with it.
   Thanks,
    -M@

pgsql-general by date:

Previous
From: "Pat Maddox"
Date:
Subject: Re: Selecting tree data
Next
From: "Dave Page"
Date:
Subject: Re: 8.2.3: Server crashes on Windows using Eclipse/Junit