Re: Logging question

Michael,
This is great info, is there a way to get the log back via a SQL call?
It would be pretty cool if there was a way to have the log go to a table
instead of a file.

Tony Caduto

Michael Fuhr wrote:

>
>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.
>
>
>