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/

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to