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

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

I sent this to the wrong mailing list.  Sorry.

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