From: | Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: psql variable to plpgsql? |
Date: | 2018-04-17 11:23:18 |
Message-ID: | 20180417132318.742840z0x0rcssu8@www.gelassene-pferde.biz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Zitat von Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Akshay Ballarpure | 2018-04-17 12:24:12 | RE: Data migration from postgres 8.4 to 9.4 |
Previous Message | Thiemo Kellner, NHC Barhufpflege | 2018-04-17 11:23:08 | Re: dblink: give search_path |