Global value/global variable? - Mailing list pgsql-general

From Edson Richter
Subject Global value/global variable?
Date
Msg-id BLU182-W1850CF79941DC481426EE9CF130@phx.gbl
Whole thread Raw
Responses Re: Global value/global variable?
List 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

pgsql-general by date:

Previous
From: Jason Long
Date:
Subject: Re: Overlapping ranges
Next
From: Ian Barwick
Date:
Subject: Re: Global value/global variable?