Re: session time
Anass HAMMEDI <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.win32 |
|---|---|
| Message-ID | <256F871A90A5D511861200B0D0216D58BBA0A1@MAIL> |
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:[email protected]] Envoyé : mardi 6 juillet 2004 16:57 À : [email protected] Cc : [email protected]; [email protected] 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings