Re: psql variable to plpgsql?

Hi

2018-04-11 8:51 GMT+02:00 Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>:

> Hi all
>
> Is there a way to pass the value of a psql variable into function code? I
> create a schema with help of psql variable
>
> \set SCHEMA_NAME LOGGER
> create
> schema :SCHEMA_NAME;
>
> I would like to create a function that has the Schema hard coded like
> declare
> V_SCHEMA_NAME text := :SCHEMA_NAME;
> begin
> but as the plpgsql code is within quotes, it Fails.
>

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

Regards

Pavel

>
> Kind regards
>
> Thiemo
>
> --
> Öffentlicher PGP-Schlüssel: http://pgp.mit.edu/pks/lookup?
> op=get&search=0x8F70EFD2D972CBEF
>
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
>
>