Re: Setting session global variables - Mailing list pgsql-sql

From Tom Lane
Subject Re: Setting session global variables
Date
Msg-id 8124.990061964@sss.pgh.pa.us
Whole thread Raw
In response to Setting session global variables  (Jonathan Bartlett <johnnyb6@SDF.lonestar.org>)
Responses Re: Setting session global variables  (Jonathan Bartlett <johnnyb6@SDF.lonestar.org>)
List pgsql-sql
Jonathan Bartlett <johnnyb6@SDF.lonestar.org> writes:
> However, the only way I can see to implement this is to have session
> global variables.  Is there a way to fake session global variables with a
> table?  Any comments would be appreciated.

You could do it with temp tables: the same temp table name would refer
to a different table in each session.

(You realize, of course, that CURRENT_USER already exists per SQL spec.
I assume you just meant that you'd like to have things *like*
CURRENT_USER, but defined by yourself...)
        regards, tom lane


pgsql-sql by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Setting session global variables
Next
From: Roberto Mello
Date:
Subject: Re: Exp/Imp Problems...