Re: Logging question

On Mon, Jan 17, 2005 at 09:03:17PM -0500, Madison Kelly wrote:

> Is there any way I can log and/or display database calls for a
> specific database?

I don't know of a way to enable logging for a specific database,
but you can enable logging for a specific user or session. For
example, you could cause johndoe's statements to be logged by doing
one of the following:

ALTER USER johndoe SET log_statement TO TRUE; -- 7.x
ALTER USER johndoe SET log_statement TO 'all'; -- 8.0

All new connections that johndoe makes will now have statement
logging enabled.

To enable logging for a particular session, execute the appropriate
"SET log_statement" statement in that session. If you have permission
problems then you could wrap that operation in a function defined
as SECURITY DEFINER and create the function as a database superuser.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/