Re: Login/logout

Thanks for the quick response.  Yes I want to retrieve the
login/logout info, but I want to insert this info in a table that I
use as an audit table. Regards

Juan P. Espino

On 6/18/05, Michael Fuhr <mike@fuhr.org> wrote:
> On Sat, Jun 18, 2005 at 11:11:31AM -0500, Juan Pablo Espino wrote:
> >
> > I want to register in an audit table the date and time of the
> > login/logout of a database user. I have been looking for some function
> > in the code but I didn't find something like that.
>
> Are you interested in logging to a table specifically, or are you
> just trying to get the login/logout info?  If the latter, then you
> can use log_connections and log_disconnections (the second of which
> is available in 8.0 and later).
>
> http://www.postgresql.org/docs/8.0/static/runtime-config.html#RUNTIME-CONFIG-LOGGING-WHAT
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>