| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Joao Miguel Ferreira <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: permanent setting of config variables |
| Date: | 2021-02-18 10:52:11 |
| Message-ID: | d8935d2d3958d899755cb4402e98aff054c5effd.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.cluster INTO _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 also be ok.
> I did read the "ALTER DATABASE " and the "set_config(...)" documentation and I experimented a bit with that but without succes.
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luca Ferrari | 2021-02-18 11:20:55 | when is pg_stat_archiver.stats_reset modified? |
| Previous Message | hubert depesz lubaczewski | 2021-02-18 09:15:53 | Re: Slow index creation |