Re: Creating a session variable in Postgres

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Nagib Abi Fadel <nagib(dot)abi-fadel(at)usj(dot)edu(dot)lb>
Cc: generalpost <pgsql-general(at)postgresql(dot)org>
Subject: Re: Creating a session variable in Postgres
Date: 2004-06-02 14:53:12
Message-ID: 200406021453.i52ErCI12605@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-06-02 15:19:23 Re: statement-level statistics are disabled error (postgresql.conf)
Previous Message Chris Ochs 2004-06-02 14:51:58 GRANT question