Logging/Viewing parameters of a prepared statement

Поиск
Список
Период
Сортировка
От Amit Phatarphekar
Тема Logging/Viewing parameters of a prepared statement
Дата
Msg-id DC4ED4C8F48DE14F9158F9DEDFFD6EC4ABD369@exch2003.visionaire.lcl
обсуждение исходный текст
Ответы Re: Logging/Viewing parameters of a prepared statement
Список pgsql-general

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: shortcut for select * where id in (arrayvar)
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: returning array from function or "structured error"