permanent setting of config variables

Поиск
Список
Период
Сортировка
От Joao Miguel Ferreira
Тема permanent setting of config variables
Дата
Msg-id CALyyT7SvhtuHCxzHT8mSpPgGiY697-yq5cwGGmuhF395EdCzqQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: permanent setting of config variables  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: permanent setting of config variables  (Joe Conway <mail@joeconway.com>)
Список pgsql-general
Hi,

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.

Thank you
Joao

В списке pgsql-general по дате отправления:

Предыдущее
От: anonymous001
Дата:
Сообщение: Re: Logical replication stuck and no data being copied
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Slow index creation