Re: session_id

--- Richard Huxton <__> wrote:

> Achilleus Mantzios wrote:
> > O Richard Huxton ������ ���� Nov 17, 2004 :
> > 
> > 
> >>Riccardo G. Facchini wrote:
> >>
> >>>hi all,
> >>>
> >>>is there a way to determine the session id on a database session?
> >>>
> >>>I would need to have a unique number whenever a session is
> started, and
> >>>have this available as a function or view result.
> > 
> > 
> > Why not SELECT pg_backend_pid();
> > ??
> 
> This is guaranteed to be unique while connected, but if you want to 
> track sessions over time isn't guaranteed to be. So, if you might
> have 
> pid=1234 now and also a month ago in a different session (especially
> if 
> you had a server reboot in-between).
> 
> Of course, if Riccardo doesn't need that, the pid is fine.
> 
> --
>    Richard Huxton
>    Archonet Ltd
> 

Ok. Taken note.

No. I don't need that, as I only need it during the session itself.
Once ended, the session info is not required over time.

thanks to all for your suggestions,

Riccardo