How to view full queries not partial queries

From: "Campbell, Lance" <lance(at)illinois(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: How to view full queries not partial queries
Date: 2013-01-03 15:17:26
Message-ID: B75CD08C73BD3543B97E4EF3964B7D701F102E04@CITESMBX1.ad.uillinois.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

PostgreSQL 9.2.2
I am using the above PostgreSQL. When in pgAdmin III (1.16) and I use the "Server Status" I will see things like:

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

How can I get this to display the actual values passed in the query?

Example of 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]<http://illinois.edu/>

Browse pgsql-admin by date

  From Date Subject
Next Message Jov 2013-01-03 15:21:30 Re: Master Archiving and replica
Previous Message Jov 2013-01-03 14:26:34 Re: Master Archiving and replica