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(at)dunslane(dot)net]
Envoyé : mardi 6 juillet 2004 16:57
À : pgman(at)candle(dot)pha(dot)pa(dot)us
Cc : Anass(dot)HAMMEDI(at)asais(dot)fr; pgsql-hackers-win32(at)postgresql(dot)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