| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "Thiemo Kellner, NHC Barhufpflege" <thiemo(dot)kellner(at)gelassene-pferde(dot)biz> |
| Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: psql variable to plpgsql? |
| Date: | 2018-04-11 12:35:18 |
| Message-ID: | CAFj8pRAOU4pvGLhzeD+HBQ5a-c0onzPHL-gebOhieiy=jETUUQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2018-04-11 11:36 GMT+02:00 Thiemo Kellner, NHC Barhufpflege <
thiemo(dot)kellner(at)gelassene-pferde(dot)biz>:
> Zitat von Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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.
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.
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexandre Arruda | 2018-04-11 12:49:40 | Re: ERROR: found multixact from before relminmxid |
| Previous Message | Laurenz Albe | 2018-04-11 11:01:19 | Re: Planning to change autovacuum_vacuum_scale_factor value to zero. Please suggest me if any negative impact. |