Postgres Pro
Downloads
Home   >   mailing lists

Re: Creating a session variable in Postgres - Mailing list pgsql-general

From Richard Huxton
Subject Re: Creating a session variable in Postgres
Date
Msg-id 40BE0759.6020601@archonet.com
Whole thread Raw
In response to Re: Creating a session variable in Postgres  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Creating a session variable in Postgres  (Mike Nolan <nolan@gw.tssi.com>)
List pgsql-general
Tree view 
Bruce Momjian wrote:
> Nagib Abi Fadel wrote:
>
>>Is it possible to create a session variable for each user in Postresql ??
>
>
> No.  The best you can do is create a temp table and put a value in
> there.

Would I be right in assuming that's going to be burning through OIDs
though (possibly an issue for a web-app with lots of short sessions).

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: ORDER BY with plpgsql parameter
Next
From: Richard Huxton
Date:
Subject: Re: ORDER BY with plpgsql parameter