Re: Connection local variables? - Mailing list pgsql-general

From Richard Huxton
Subject Re: Connection local variables?
Date
Msg-id 42C2477F.7050808@archonet.com
Whole thread Raw
In response to Connection local variables?  ("Steve - DND" <postgres@digitalnothing.com>)
List pgsql-general
Steve - DND wrote:
> Is there a way to create a variable specific to the current working
> connection? Like a connection context or some such? I'm trying to take a
> variable in a query, and allow it to be used by a rule.

You can create functions in a language that allows global storage.
Search in the archives for "app_session tcl" for examples of what I use.
   http://archives.postgresql.org/

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Advice on merging two primary keys...
Next
From: "Zlatko Matic"
Date:
Subject: Re: automating backup ?