Hi all.
I'm trying to use a psql variable in a DO-block, but it fails:
\set resource_group 'Ressurser' \set quoted_resource_group '\''
:resource_group '\'' DO $$ begin if not exists(SELECT * FROM tbl_group WHERE
groupname = :quoted_resource_group)then raise notice 'Group % not found,
creating it.', :quoted_resource_group; end if; end; $$;
ERROR: syntax error at or near ":"
LINE 3: ... exists(SELECT * FROM tbl_group WHERE groupname = :quoted_re...
^
Any hints?
-- 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>