Here is a link to the doc you need. http://www.postgresql.org/idocs/index.php?runtime-config.html#LOGGING
DEBUG_PRINT_QUERY (boolean) DEBUG_PRINT_PARSE (boolean) DEBUG_PRINT_REWRITTEN (boolean) DEBUG_PRINT_PLAN (boolean) DEBUG_PRETTY_PRINT (boolean) Hope this helps Phil ----- Original Message ----- From: "Nick Fankhauser" <[EMAIL PROTECTED]> To: "pgsql-admin" <[EMAIL PROTECTED]> Sent: Monday, September 23, 2002 6:05 PM Subject: [ADMIN] logging queries > Hi- > > I'd like to set the logging or debug level so that the text of the queries > that are executed show up in the log file. It seems to me that I recall this > being discussed before, but I can't find any specific references in the > runtime-config portion of the docs. > > Can someone tell me if this is possible & if so, what runtime settings are > needed? > > Thanks > > -Nick > > -------------------------------------------------------------------------- > Nick Fankhauser [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788 > Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])