Re: session time - Mailing list pgsql-hackers-win32

From Bruce Momjian
Subject Re: session time
Date
Msg-id 200407061346.i66Dkcs16102@candle.pha.pa.us
Whole thread Raw
In response to session time  (Anass HAMMEDI <Anass.HAMMEDI@asais.fr>)
Responses Re: session time
List 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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-hackers-win32 by date:

Previous
From: nitrogenycs@web.de
Date:
Subject: Re: initdb crash
Next
From: "Andrew Dunstan"
Date:
Subject: Re: session time