Logging/Viewing parameters of a prepared statement

Started by Amit Phatarphekarabout 18 years ago2 messagesgeneral
Jump to latest
#1Amit Phatarphekar
amit@visionaire-us.com

I'm using Version-8.1.4 and JDBC-3 jar

I call a db function from my java code, using a prepared statement.

When I look at the logs of postgres in data/pg_log, the statement
executed appears like for example

"select * from get_user($1)"

It would be nice if I can somehow know the value of $1 passed in. So
Ideally a statement like

"select * from get_user(1234)" (where 1234 is $1), would be more
helpful.

This is all in efforts to make debugging easier. For instance using MS
SQL Server's Profiler, you can monitor

all statements executing on the db. I'm trying to achieve that on
postgres.

I've configured the log_statement='all' in postgresql.conf.

Thanks

Amit

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Amit Phatarphekar (#1)
Re: Logging/Viewing parameters of a prepared statement

"Amit Phatarphekar" <amit@visionaire-us.com> writes:

I'm using Version-8.1.4 and JDBC-3 jar
...
It would be nice if I can somehow know the value of $1 passed in.

This is fixed in 8.2 and up.

regards, tom lane