Re: permanent setting of config variables

On Thu, 2021-02-18 at 09:09 +0000, Joao Miguel Ferreira wrote:
> I have a few PL/pgSQL functions that use queires like "SHOW company.product INTO _product_name" and "SHOW
company.clusterINTO _cluster_number".
 
> But these are failing because I don't know how to set those values on a permanent basis, or maybe on startup would
alsobe ok.
 
> I did read the "ALTER DATABASE " and the "set_config(...)" documentation and I experimented a bit with that but
withoutsucces.
 
> So my question would be: how to permanently set user specific config values that would become accessible to the "SHOW
...."SQL comand.
 

_product_name := current_setting('company.product');

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com