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

From Thiemo Kellner
Subject Re: psql variable to plpgsql?
Date
Msg-id 20180417132318.742840z0x0rcssu8@www.gelassene-pferde.biz
Whole thread Raw
In response to Re: psql variable to plpgsql?  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Zitat von Pavel Stehule <pavel.stehule@gmail.com>:

> 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.

Hi Pavel, thanks for pointing this out. However, I implemented another
solution with dedicated PostgreSQL user where I do not need such
variables in literals.

--
Ö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: "Thiemo Kellner, NHC Barhufpflege"
Date:
Subject: Re: dblink: give search_path
Next
From: Adrian Klaver
Date:
Subject: Re: pg_dump to a remote server