Re: psql variable to plpgsql?

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: psql variable to plpgsql?
Дата
Msg-id CAFj8pRAOU4pvGLhzeD+HBQ5a-c0onzPHL-gebOhieiy=jETUUQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psql variable to plpgsql?  ("Thiemo Kellner, NHC Barhufpflege"<thiemo.kellner@gelassene-pferde.biz>)
Ответы Re: psql variable to plpgsql?  (Thiemo Kellner <thiemo@gelassene-pferde.biz>)
Список pgsql-general
Дерево обсуждения


2018-04-11 11:36 GMT+02:00 Thiemo Kellner, NHC Barhufpflege <thiemo.kellner@gelassene-pferde.biz>:
Zitat von Pavel Stehule <pavel.stehule@gmail.com>:

No, there is not possible to read/write client side variables from server
side.

 I did not mean that the variable be replaced by its value at execution time but at Installation time.

no. The :xxx is not evaluated inside string. The workaround is using GUC variables and related functions. Can be used from psql and from plpgsql too.

https://stackoverflow.com/questions/13172524/passing-user-id-to-postgresql-triggers/13172964#13172964

Regards

Pavel

 


--
Öffentlicher PGP-Schlüssel: http://pgp.mit.edu/pks/lookup?op=get&search=0x8F70EFD2D972CBEF

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.


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

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Planning to change autovacuum_vacuum_scale_factor value tozero. Please suggest me if any negative impact.
Следующее
От: Alexandre Arruda
Дата:
Сообщение: Re: ERROR: found multixact from before relminmxid