Re: Custom runtime variables
От | Andreas Kretschmer |
---|---|
Тема | Re: Custom runtime variables |
Дата | |
Msg-id | 20090626085808.GA14663@tux обсуждение исходный текст |
Ответ на | Re: Custom runtime variables (Scott Bailey <artacus@comcast.net>) |
Ответы |
Re: Custom runtime variables
|
Список | pgsql-general |
Scott Bailey <artacus@comcast.net> wrote: > Thanks Tom. So how about accessing it from from plpgsql or sql? test=# select * from current_setting('myvar.foo'); current_setting ----------------- (1 Zeile) Zeit: 0,163 ms test=*# test=*# set myvar.foo='bla'; SET Zeit: 0,117 ms test=*# select * from current_setting('myvar.foo'); current_setting ----------------- bla (1 Zeile) Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
В списке pgsql-general по дате отправления: