----- Original Message ----- From: "Andreas Kretschmer" <[email protected]> To: [email protected] Sent: Friday, June 26, 2009 1:58:08 AM GMT -08:00 US/Canada Pacific Subject: Re: [GENERAL] Custom runtime variables
Scott Bailey <[email protected]> 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.
