----- Original Message ----- From: "Andreas Kretschmer" <akretsch...@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 <arta...@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.