Scott Bailey <artacus@xxxxxxxxxxx> 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?
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
