| 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: | Whole Thread | Raw Message | 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 |