Обсуждение: How to display full query in logs

Поиск
Список
Период
Сортировка

How to display full query in logs

От
"Campbell, Lance"
Дата:

PostgreSQL 9.2.2

Is there a configuration parameter in PostgreSQL that will allow a full query to be displayed in the log file?

 

What I see:

UPDATE abc.table set def=$1 WHERE id=$2

 

What I want to see:

UPDATE abc.table set def=’hi bob’ WHERE id=12

 

 

Thanks,

 

Lance Campbell

Software Architect

Web Services at Public Affairs

217-333-0382

University of Illinois at Urbana-Champaign logo

 

 

Вложения

Re: How to display full query in logs

От
Tom Lane
Дата:
"Campbell, Lance" <lance@illinois.edu> writes:
> What I see:
> UPDATE abc.table set def=$1 WHERE id=$2

> What I want to see:
> UPDATE abc.table set def='hi bob' WHERE id=12

It doesn't work that way.  What you should be seeing, though, is that
the value of each parameter is included in a DETAIL line just after
the statement text.

            regards, tom lane