Skip site navigation (1)
Skip section navigation (2)
With 8.2.4 is it possible to get Postgres to log incoming SQL statements the same as they look when written? Instead of:
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 26 Oct 2007 10:34:32 -0700
- Message-id: <BB3CF982-D896-4859-BB7E-58117C57169B(at)poindextrose(dot)org>
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@
- Follow-Ups:
- Re: change format of logging statements?
- From: Tom Lane
- Re: change format of logging statements?
- Prev by Date: Re: Selecting tree data
- Next by Date: Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
- Previous by thread: cases in rules problem
- Next by thread: Re: change format of logging statements?
- Indexes: