Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1us3pU-00GpLv-99 for pgsql-admin@arkaria.postgresql.org; Fri, 29 Aug 2025 18:28:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1us3pT-00ByTo-Nh for pgsql-admin@arkaria.postgresql.org; Fri, 29 Aug 2025 18:28:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1us3pT-00ByTf-CY for pgsql-admin@lists.postgresql.org; Fri, 29 Aug 2025 18:28:04 +0000 Received: from mail-ot1-x32e.google.com ([2607:f8b0:4864:20::32e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1us3pR-002YGM-2U for pgsql-admin@lists.postgresql.org; Fri, 29 Aug 2025 18:28:03 +0000 Received: by mail-ot1-x32e.google.com with SMTP id 46e09a7af769-74567ffe649so18050a34.2 for ; Fri, 29 Aug 2025 11:28:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1756492080; x=1757096880; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=0I23Tgd9zqejQmkfu0Ea5Ix5O3VvhJbRWyOHAq93gws=; b=eB5IIl+fTRvsOSSv0ZRv9E2j+X7JeZBYAXpdX5O/0eZhqSYlKNtBBqIMLEtWVWSZ/E VMepZJiIwIatDXlCUPQ+gpdZ42OkMkPY4uuvtv4WiCH4f24iONPWeUzyJ/wUlQ6uVhM0 EHqtwydqdGHGr0bIok593p2BxHppdElmxSz4Izu6AN7d/WZzpVpuZPXW023TnPhSMeyY dmb0MoqWlQUVd16D5Sr5UWVDHkmeMyisOk+ggrYdY+31+M2dR1UeAm5jXe4bVvWKB1C5 Wx6RhtySOLWyHwIRF16y/0gPwnV4yRF4GrTYvOltCTZSBZqEra0Na9F20s0OVsMSOp1y 4jnQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1756492080; x=1757096880; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=0I23Tgd9zqejQmkfu0Ea5Ix5O3VvhJbRWyOHAq93gws=; b=NbRuTvFvCO+AVOTjK4iEAJ669vcYEpWnFD5V2xgTVvUwz/pBaGo4e/wwlzKdY7UcIG mqvcgwE17aA9xiz9fcLHrrWCU9TPFnlWllCvsIE2m4iDQsDiq4zrAMI3hA7VWRbq3OtX AOo6e8F6gbrWBbCgCJ/768cvl4YQd0m7FajL5O73FuEz7+19YdSvee8QgQIp96+TV5x1 lqACOB6gXtctU1XAfD+Xfk2HEE5Yr7oBwZOmDYuYXP7zj9V1cMyX7kNoD0SmoOesIdFf cCn2yKHJYun6I+h/EAsK1d3fqf4gxnGeT1I8S1sj77TjzdeLZsyYl2gBuJHnhL96bqlD lmtQ== X-Gm-Message-State: AOJu0Yx6YwTDRldJyS+n53lBu5CSB1sPCt22cyqJP70fLyBae0DGkbBT suqn9y73yV0NWRf3RrQ4Fi3Eyz8/8Bc3AOrWL9vkdLoSjXwQH1hxqXwMuasDiK4oS+BLkisXAnK fvU1q0BOGR9I83YalfmIabw34Y6V6nj2Dj6sR X-Gm-Gg: ASbGncvnVqDkwH13npa/255gaNxta/UPBQgPkGY7gDzPPE37Pb2PpWvBlx64Nm0dKbY QtgNVzAJ/szXCYyVfpczZKz+DTsBKnNN66PKBKWbYZx+IU9RCtUtk9vIfDymlQBwt0dwHIZbHUg 6O7BSAhZklqKPx2w4IJPrDES5+dpE+KtSxpkG85sRTETk4sHHPJHXtXWC0tTRNjKlLe39tZAFdO EjGEpKfUP8riQuiJz8= X-Google-Smtp-Source: AGHT+IEOVT4Al9vz10asEE32QdsiyP2uI0HyqHOKTdQ1boXNF42x0kE/bFdaJl0y7TroDeJSFXsBopMy5An4TLqCxHg= X-Received: by 2002:a05:6808:6901:b0:435:6d69:a824 with SMTP id 5614622812f47-4378516ca8dmr15548388b6e.1.1756492079783; Fri, 29 Aug 2025 11:27:59 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Fri, 29 Aug 2025 14:27:49 -0400 X-Gm-Features: Ac12FXyX6er5gIOt1NjSj8TSXUDJjchQY2L3BV7oEBu1eg2FrXYm_4NkYYiLQt4 Message-ID: Subject: Re: Having trouble passing a shell variable to a query from psql command line To: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000776321063d852e26" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000776321063d852e26 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, Aug 29, 2025 at 1:52=E2=80=AFPM Murthy Nunna wrot= e: > Hello, > > > > Below works: > > > > psql -d mydb -t -A -c "SELECT relkind FROM pg_class WHERE relname =3D > 'pg_trigger' ;" > > r > > > > I am getting syntax error from following: > > > > echo $SHELL_VAR > > pg_trigger > > > > psql -d mydb -t -A -c "SELECT relkind FROM pg_class WHERE relname =3D > :'SHELL_VAR' ;" -v SHELL_VAR=3D"$SHELL_VAR" > > ERROR: syntax error at or near ":" > > LINE 1: SELECT relkind FROM pg_class WHERE relname =3D :'SHELL_VAR' ; > > ^ > > Is psql script necessary to pass shell variable? > Yeah. From the cli KISS and do regular bash variable string expansion. psql -d mydb -tAc "SELECT relkind FROM pg_class WHERE relname =3D ${SHELL_VAR} ;" --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000776321063d852e26 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Fri, Aug 29, 2025 at 1:52=E2=80=AFPM M= urthy Nunna <mnunna@fnal.gov> = wrote:

Hello,

=C2=A0

Below works:

=C2=A0

psql -d mydb -t -A -c "SELECT relkind FROM pg_c= lass WHERE relname =3D 'pg_trigger' ;"

r

=C2=A0

I am getting syntax error from following:<= /u>

=C2=A0

echo $SHELL_VAR

pg_trigger

=C2=A0

psql -d mydb -t -A -c "SELECT relkind FROM pg_c= lass WHERE relname =3D :'SHELL_VAR' ;" -v SHELL_VAR=3D"$S= HELL_VAR"

ERROR:=C2=A0 syntax error at or near ":"

LINE 1: SELECT relkind FROM pg_class WHERE relname = =3D :'SHELL_VAR' ;

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ^

Is psql script necessary to pass shell variable?<= /u>


Yeah.=C2= =A0 From the cli KISS and do regular bash variable string expansion.
<= div>=C2=A0
psql -d mydb -tAc "SELECT relkind FROM pg_c= lass WHERE relname =3D ${SHELL_VAR} ;"

--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lobs= ter!
--000000000000776321063d852e26--