Re: session_id

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.

Add a new sequence to your database:  CREATE SEQUENCE my_session_id;

Then, at the start of every session:  SELECT nextval('my_session_id');

and whenever you need the value:  SELECT currval('my_session_id');

Sequences are concurrency-safe, so you're OK with multiple clients. They 
return INT8 values, so you should be good for unique numbers for a while.

The only thing is, you need to remember to call nextval() every time you 
connect.

HTH
--   Richard Huxton  Archonet Ltd