On Thu, 2013-01-03 at 16:11 +0000, Campbell, Lance wrote: > PostgreSQL 9.2.2 > pgAdmin 1.16.1 > pgAdmin > Tools > Server Status > > When viewing the Server Status window I notice that my queries look like this: > > SELECT * FROM tablex WHERE id=$1 > > How can I display the full query without the $1? >
Is it in the activity pane? I don't think so. I would bet it is in the log pane, right? > Example of what I would like to see: > > SELECT * FROM tablex where id=75 > > I would assume this is some kind of setting within the PostgreSQL database > log configuration. But I am at a loss on what I need to set in order to have > the parameters populated. > If it is in the log pane (which means it is in you log files), there's no setting that will replace $1 with the runtime value. IIRC, you have the actual value below in recent releases. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
