Re: database session variables - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: database session variables
Date
Msg-id 20021001234939.GA2408@svana.org
Whole thread Raw
In response to database session variables  ("Mark Wilson" <mark@mediasculpt.com>)
List pgsql-general
On Wed, Oct 02, 2002 at 10:27:10AM +1200, Mark Wilson wrote:
> Hi all,
>
> I am working on a system architecture that requires accessing session
> variables specific to the database connection.  This is useful because you
> can emulate many users (with different privileges) with a single database
> logon.  Currently it seems like only user, current_user and session_user
> are supported.

Well, you can get the process ID of the backend process. This would be
different for every connection.

What other database allow you to store session specific variables?
--
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.

pgsql-general by date:

Previous
From: Darren Ferguson
Date:
Subject: Re: Major Problem with locale
Next
From: Justin Clift
Date:
Subject: New PostgreSQL Website : advocacy.postgresql.org