Global value/global variable?

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Global value/global variable?
Date: 2014-06-19 02:50:11
Message-ID: BLU182-W1850CF79941DC481426EE9CF130@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.
Regards,
Edson

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Barwick 2014-06-19 03:08:04 Re: Global value/global variable?
Previous Message Jason Long 2014-06-19 00:45:45 Re: Overlapping ranges