Sv: Using psql variables in DO-blocks - Mailing list pgsql-general

\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;
$$;