Postgres Pro
Downloads
Home   >   mailing lists

Re: psql variable to plpgsql? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: psql variable to plpgsql?
Date
Msg-id CAFj8pRAOU4pvGLhzeD+HBQ5a-c0onzPHL-gebOhieiy=jETUUQ@mail.gmail.com
Whole thread Raw
In response to Re: psql variable to plpgsql?  ("Thiemo Kellner, NHC Barhufpflege"<thiemo.kellner@gelassene-pferde.biz>)
Responses Re: psql variable to plpgsql?  (Thiemo Kellner <thiemo@gelassene-pferde.biz>)
List pgsql-general
Tree view


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 by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Planning to change autovacuum_vacuum_scale_factor value tozero. Please suggest me if any negative impact.
Next
From: Alexandre Arruda
Date:
Subject: Re: ERROR: found multixact from before relminmxid