On Sat, 2005-06-18 at 11:46 -0500, Juan Pablo Espino wrote: > 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
I suggest putting together a short script to scan the logs periodically and add the new entries to your table. > On 6/18/05, Michael Fuhr <[EMAIL PROTECTED]> 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/ > > > > ---------------------------(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 > -- ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
