Using psql variables in DO-blocks

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Using psql variables in DO-blocks
Date: 2019-01-15 15:51:09
Message-ID: VisenaEmail.ac.52245673f23b65b6.16852332064@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-01-15 15:54:57 Re: Refining query statement
Previous Message Thomas Kellerer 2019-01-15 15:47:32 Re: Refining query statement