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:
and whenever you need the value:
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
In response to
- session_id at 2004-11-17 13:13:43 from Riccardo G. Facchini
pgsql-sql by date
|Next:||From: Riccardo G. Facchini||Date: 2004-11-17 14:25:25|
|Subject: Re: session_id|
|Previous:||From: Riccardo G. Facchini||Date: 2004-11-17 13:13:43|