| From: | "Riccardo G(dot) Facchini" <abief_ag_-postgresql(at)yahoo(dot)com> |
|---|---|
| To: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | abief_ag_-postgresql(at)yahoo(dot)com, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: session_id |
| Date: | 2004-11-17 14:27:32 |
| Message-ID: | 20041117142732.60975.qmail@web13912.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleus Mantzios | 2004-11-17 14:33:03 | Re: session_id |
| Previous Message | Riccardo G. Facchini | 2004-11-17 14:25:25 | Re: session_id |