I've ended creating a table to store database parameters, and using a subquery, I can achieve the "global variable" effect.
Thanks for your insight,
Edson.
From: edsonrichter@hotmail.com To: pgsql-general@postgresql.org Subject: Re : [GENERAL] Global value/global variable? Date: Thu, 19 Jun 2014 14:39:45 +0000
Yes. It's similar, but consider I'm using a connection pool, so I''ve no control on when the connections are established/destroyed.
I think I need something with scope broader than session...
Atenciosamente,
Edson Richter
------ Mensagem original ------ De: John McKown Data: 19/06/2014 8h44 Para: Edson Richter; Assunto:Re: [GENERAL] Global value/global variable?
A psql session is shown below:
tsh009=# \set lpar '\'LIH1\''
tsh009=# select * from capped where lpar=:lpar limit 5;
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
--
There is nothing more pleasant than traveling and meeting new people!