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/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
