Using psql variables in DO-blocks

[Andreas Joseph Krogh <andreas@xxxxxxxxxx>]

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@xxxxxxxxxx

www.visena.com