Re: session time

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Anass HAMMEDI <Anass(dot)HAMMEDI(at)asais(dot)fr>
Cc: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: session time
Date: 2004-07-06 13:46:38
Message-ID: 200407061346.i66Dkcs16102@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32

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.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Andrew Dunstan 2004-07-06 14:57:16 Re: session time
Previous Message nitrogenycs 2004-07-05 16:46:30 Re: initdb crash