----- Original Message -----
From: "Andreas Kretschmer" <akretschmer@spamfence.net>
To: pgsql-general@postgresql.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@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)
Thanks Pavel and Andreas.