> Scott Bailey <artacus(at)comcast(dot)net> writes:
>> I added the following lines to my postgresql.conf file:
>> custom_variable_classes = 'foo'
>> foo.name = '1s'
>> Now if I do "show foo.name" I get '1s'
>> But it does not show up in show all or in pg_settings.
> No, it doesn't. It should still work in set/show though.
>> Also, can the variable be stored in a specific data type or am I stuck
>> with text?
> There's no data type associated with it. This is all an artifact of the
> fact that this isn't a genuine designed-in feature, but a kluge that
> someone shoehorned in. You should have to declare the variable in some
> regards, tom lane
Thanks Tom. So how about accessing it from from plpgsql or sql?
In response to
pgsql-general by date
|Next:||From: Pavel Stehule||Date: 2009-06-26 08:49:25|
|Subject: Re: Custom runtime variables|
|Previous:||From: Knut P. Lehre||Date: 2009-06-26 08:26:40|
|Subject: PL/pgSQL EXECUTE quote_ident(), and SQL injection|