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