Re: database session variables

It is in the Statistics Collector section of the 7.2.1 documentation
http://www.postgresql.org/idocs/index.php?monitoring-stats.html

But I'm a bit of a newbie at PostgreSQL and don't know how to install this
library in the database or access it if it is already installed.  Do you
know how?

Cheers,
Mark

----- Original Message -----
From: "Martijn van Oosterhout" <kleptog@svana.org>
To: "Mark Wilson" <mark@mediasculpt.com>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, October 02, 2002 2:06 PM
Subject: Re: [GENERAL] database session variables


> On Wed, Oct 02, 2002 at 01:48:46PM +1200, Mark Wilson wrote:
> > Thanks Martijin,
> >
> > It sounds like the process_id is the 'correct' name for what I was
calling
> > session_id, and is what I want.  To answer your question, Oracle lets
you
> > have session specific variables, via package variables.
>
> Hmm, the client can get it using $conn->backendPID in perl or PQbackendPID
> in C. I don't know how you do it from the backend itself.
> --
> Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> > There are 10 kinds of people in the world, those that can do binary
> > arithmetic and those that can't.
>
>