Re: session_id - Mailing list pgsql-sql

From Riccardo G. Facchini
Subject Re: session_id
Date
Msg-id 20041117142732.60975.qmail@web13912.mail.yahoo.com
Whole thread Raw
In response to Re: session_id  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-sql
--- 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();
> ??
> 
> > 
[..]

that could work. Is this the unique value for my own session? can
somebody confirm it?

regards,

R.



pgsql-sql by date:

Previous
From: "Riccardo G. Facchini"
Date:
Subject: Re: session_id
Next
From: Richard Huxton
Date:
Subject: Re: session_id