Home > mailing lists

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

From	Campbell, Lance
Subject	Re: How to display full query in logs
Date	January 8, 2013 18:51:22
Msg-id	B75CD08C73BD3543B97E4EF3964B7D701F10811D@CITESMBX1.ad.uillinois.edu Whole thread Raw
In response to	How to display full query in logs ("Campbell, Lance" <lance@illinois.edu>)
List	pgadmin-support

Tree view

I sent this to the wrong mailing list. Sorry.

Thanks,

Lance Campbell

Software Architect

Web Services at Public Affairs

217-333-0382

From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Campbell, Lance
Sent: Tuesday, January 08, 2013 9:46 AM
To: pgadmin-support@postgresql.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

Attachment

image001.png

pgadmin-support by date:

From: "Campbell, Lance"
Date: 08 January 2013, 18:45:55
Subject: How to display full query in logs

From: Vikram A
Date: 10 January 2013, 10:54:00
Subject:

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

Attachment

Previous

Next