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