Re: session time

I 'm trying to convince my chief to add PostgreSQL to RDBMS 's our software
supports.
I need to know how to get the session time by a simple query , to prohibit
idling on the server.

I think this feature would be useful not just for me , so if it can be added
,please, give it your best shot.

Thanx

Anass

-----Message d'origine-----
De : Andrew Dunstan [mailto:andrew@dunslane.net]
Envoyé : mardi 6 juillet 2004 16:57
À : pgman@candle.pha.pa.us
Cc : Anass.HAMMEDI@asais.fr; pgsql-hackers-win32@postgresql.org
Objet : Re: [pgsql-hackers-win32] session time


Bruce Momjian said:
> Anass HAMMEDI wrote:
>>
>> Help requested:
>>
>> Is there any way to get the session time with a query.
>> All I afforded to get is the start time of statement execution.
>
> You want session start time?  We don't supply that.  My only suggestion
> would be to create a temp table on session start and put
> current_timestamp into there.
>

log_line-prefex on 7.5 does session start time. We could also add a 'time
since session start' if that was wanted quite easily.

cheers

andrew