Re: change format of logging statements?

From: Matthew Hixson <hixson(at)poindextrose(dot)org>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: change format of logging statements?
Date: 2007-10-26 17:34:32
Message-ID: BB3CF982-D896-4859-BB7E-58117C57169B@poindextrose.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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@

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pat Maddox 2007-10-26 18:07:11 Re: Selecting tree data
Previous Message Michael Glaesemann 2007-10-26 17:29:11 Re: Selecting tree data