Re: Setting session global variables

Yes, that's perfect! Actually, I was thinking of a real user, but more
in the fashion of "pretend" users. If you've ever used Oracle apps, it
would be like an apps user, not the user "apps".

Anyway, that's an excellent idea. Thank you much!

Jon

johnnyb6(at)sdf(dot)lonestar(dot)org
SDF Public Access UNIX System - http://sdf.lonestar.org

On Wed, 16 May 2001, Tom Lane wrote:

> Jonathan Bartlett <johnnyb6(at)SDF(dot)lonestar(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>