Re: Temp tables as session var containers

From: Richard Huxton <dev(at)archonet(dot)com>
To: James Croft <james(dot)croft(at)lumison(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Temp tables as session var containers
Date: 2005-05-19 17:32:50
Message-ID: 428CCDC2.2050206@archonet.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

James Croft wrote:
> Hi,
>
> I've seen the session variable question pop up a fair bit on this list.
> The temporary table solution seems good but I've got a question before
> using it...

Another option is to use one of the procedural languages that provide
global variable storage. The attached examples are in TCL.

Set the user-id
SELECT app_session('UID', 'ABC1234');
Get the user-id
SELECT app_session('UID');

--
Richard Huxton
Archonet Ltd

Attachment Content-Type Size
session_functions.txt text/plain 1.9 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard_D_Levine 2005-05-19 17:39:47 Re: Postgres in government
Previous Message Joshua D. Drake 2005-05-19 17:30:41 Re: Postgres in government