Search Postgresql Archives

Re: psql variable to plpgsql?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





2018-04-11 11:36 GMT+02:00 Thiemo Kellner, NHC Barhufpflege <thiemo.kellner@xxxxxxxxxxxxxxxxxxxx>:
Zitat von Pavel Stehule <pavel.stehule@xxxxxxxxx>:

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.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux