From: | Ian Barwick <ian(at)2ndquadrant(dot)com> |
---|---|
To: | Edson Richter <edsonrichter(at)hotmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Global value/global variable? |
Date: | 2014-06-19 03:08:04 |
Message-ID: | 53A25414.9030902@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 19/06/14 11:50, Edson Richter wrote:
> It is possible to define a global value/variable in PostgreSQL in a way that I can use it in any query/view/function?
> For example, I do have a connection string I use for dblink connections in several places (specially, inside views).
> Then, if I want to change the connection string, I do have to change every view manually.
> If I can set a kind of global variable, then I just use it inside every view - then, at my application startup (or even at PostgreSQL startup, if I can set this string at postgresql.conf level), would set this "global variable" to point the current string.
>
> Your enlightment will be really welcome.
There's no such thing as a global variable, but why not use a table
to store any global configuration values? You can always do something like this:
SELECT dblink_connect('myconn', (select connstr from dblink_conf))
Regards
Ian Barwick
--
Ian Barwick http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-06-19 03:13:36 | Re: Global value/global variable? |
Previous Message | Edson Richter | 2014-06-19 02:50:11 | Global value/global variable? |