Re: Custom runtime variables

> Scott Bailey <artacus@comcast.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
> fashion...
>
>             regards, tom lane

Thanks Tom. So how about accessing it from from plpgsql or sql?