Re: Custom runtime variables

----- Original Message -----
From: "Andreas Kretschmer" <akretschmer(at)spamfence(dot)net>
To: pgsql-general(at)postgresql(dot)org
Sent: Friday, June 26, 2009 1:58:08 AM GMT -08:00 US/Canada Pacific
Subject: Re: [GENERAL] Custom runtime variables

Scott Bailey <artacus(at)comcast(dot)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)

Thanks Pavel and Andreas.