From: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
---|---|
To: | "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za> |
Cc: | Pgsql Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Logging |
Date: | 2001-11-30 15:04:44 |
Message-ID: | Pine.LNX.4.30.0111301002080.3357-100000@chapelperilous.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice pgsql-sql |
On Fri, 30 Nov 2001, Duncan Adams (DNS) wrote:
> I was wondering if there is any way to track/log what sql commands have been
> send to the postgres database from an external source. For example, from a
> PHP/pearl script.
Yes, there is. I believe if you set DEBUG_PRINT_QUERY in postgresql.conf,
it will log the queries.
See http://www.postgresql.org/idocs/index.php?runtime-config.html#LOGGING
for more details.
-- Brett
http://www.chapelperilous.net/
------------------------------------------------------------------------
The turtle lives 'twixt plated decks
Which practically conceal its sex.
I think it clever of the turtle
In such a fix to be so fertile.
-- Ogden Nash
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-11-30 15:07:17 | Re: Using temp tables with web apps (No State) |
Previous Message | Rob Arnold | 2001-11-30 13:11:17 | Re: Learning to read explain |
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Eckermann | 2001-11-30 15:38:54 | Re: contracting tables |
Previous Message | Martín Marqués | 2001-11-30 13:43:43 | variables in procedures |