Hi, thanks for the response.
On 6/18/05, Rod Taylor <[EMAIL PROTECTED]> wrote:
> 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.
>
It sounds to me good in order to resolve my problem. Nevertheless I
think that it would be very useful to have a function that does
something like "select login()" and gives back to the date and time of
login, or that we can retrieve that info from the system catalogs.
Regards,
Juan P. Espino
---------------------------(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
