Sv: Using psql variables in DO-blocks

På tirsdag 15. januar 2019 kl. 16:51:09, skrev Andreas Joseph Krogh <
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>>:
Hi all.
 
I'm trying to use a psql variable in a DO-block, but it fails:
 
[snip]
 
Seems I was a bit lazy, here's what works:
 
\set resource_group 'Ressurser' \set quoted_resource_group '\''
:resource_group '\'' set myvars.quoted_resource_group to :quoted_resource_group;
DO$$ begin if not exists(SELECT * FROM onp_group WHERE groupname =
current_setting('myvars.quoted_resource_group')) then raise notice 'Group %
not found, creating it.', current_setting('myvars.quoted_resource_group'); end
if; end; $$;
 
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>