Sv: Using psql variables in DO-blocks

På tirsdag 15. januar 2019 kl. 16:51:09, skrev Andreas Joseph Krogh < andr...@visena.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_resour

Re: Using psql variables in DO-blocks

On Tue, Jan 15, 2019 at 8:48 AM Andreas Joseph Krogh wrote: > Hi all. > > I'm trying to use a psql variable in a DO-block, but it fails: > [...] > Any hints? > Don't do that. The body of a DO block is a string literal and psql won't and shouldn't mess with its contents. You'll need to use an

Using psql variables in DO-blocks

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, creat