How to display full query in logs - Mailing list pgsql-admin

From Campbell, Lance
Subject How to display full query in logs
Date
Msg-id B75CD08C73BD3543B97E4EF3964B7D701F1080DD@CITESMBX1.ad.uillinois.edu
Whole thread Raw
Responses Re: How to display full query in logs  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin

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

 

 

Attachment

pgsql-admin by date:

Previous
From: Lars Aksel Opsahl
Date:
Subject: Re: Postgres base Backup fails to recover all logs fails from archive
Next
From: Tom Lane
Date:
Subject: Re: How to display full query in logs