2009/6/26 Scott Bailey <arta...@comcast.net>: > >> Scott Bailey <arta...@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?
look on http://www.postgresql.org/docs/8.3/interactive/functions-admin.html#FUNCTIONS-ADMIN-SET-TABLE regards Pavel Stehule > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
