Re: How to display full query in logs

From: "Campbell, Lance" <lance(at)illinois(dot)edu>
To: "Campbell, Lance" <lance(at)illinois(dot)edu>, "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: How to display full query in logs
Date: 2013-01-08 15:51:15
Message-ID: B75CD08C73BD3543B97E4EF3964B7D701F10811D@CITESMBX1.ad.uillinois.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I sent this to the wrong mailing list. Sorry.

Thanks,

Lance Campbell
Software Architect
Web Services at Public Affairs
217-333-0382
[University of Illinois at Urbana-Champaign logo]<http://illinois.edu/>

From: pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Campbell, Lance
Sent: Tuesday, January 08, 2013 9:46 AM
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] 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
[University of Illinois at Urbana-Champaign logo]<http://illinois.edu/>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Vikram A 2013-01-10 07:53:54
Previous Message Campbell, Lance 2013-01-08 15:45:50 How to display full query in logs