How to display full query in logs - Mailing list pgadmin-support

From Campbell, Lance
Subject How to display full query in logs
Date
Msg-id B75CD08C73BD3543B97E4EF3964B7D701F108057@CITESMBX1.ad.uillinois.edu
Whole thread Raw
Responses Re: How to display full query in logs
List pgadmin-support

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

 

 

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: how to build pgadmin3 when wxgtk was built with --disable-unicode ?
Next
From: "Campbell, Lance"
Date:
Subject: Re: How to display full query in logs