----- Original Message -----
From: "Andreas Kretschmer" <akretschmer@xxxxxxxxxxxxx>
To: pgsql-general@xxxxxxxxxxxxxx
Sent: Friday, June 26, 2009 1:58:08 AM GMT -08:00 US/Canada Pacific
Subject: Re: Custom runtime variables
Scott Bailey <artacus@xxxxxxxxxxx> 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)
Thanks Pavel and Andreas.
