MIME-Version: 1.0
References: <DM8PR09MB6677C5B4FDBDFC0F82298DC7B8DE2@DM8PR09MB6677.namprd09.prod.outlook.com>
In-Reply-To: <DM8PR09MB6677C5B4FDBDFC0F82298DC7B8DE2@DM8PR09MB6677.namprd09.prod.outlook.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Thu, 4 Jul 2024 18:16:32 -0700
Message-ID: <CAKFQuwaYLtg0W4He0VGfqSTKSj+69sSq_5esqBVTHwSrPfMLmw@mail.gmail.com>
Subject: Re: psql help
To: Murthy Nunna <mnunna@fnal.gov>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a763eb061c75d25d"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwaYLtg0W4He0VGfqSTKSj%2B69sSq_5esqBVTHwSrPfMLmw%40mail.gmail.com>
Precedence: bulk

--000000000000a763eb061c75d25d
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Jul 4, 2024 at 4:56=E2=80=AFPM Murthy Nunna <mnunna@fnal.gov> wrote=
:

>
>
> How can I rewrite the above in psql
>

The only real trick is using a psql variable instead of the shell-injection
of the environment variable.  Use the --set CLI argument to assign the
environment variable to a psql variable then refer to it in the query using
:'timout_mins'

Removing the limit 1 should be as simple as not typing limit 1 when you
bring the query into the psql script.

David J.

--000000000000a763eb061c75d25d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Thu, Jul 4, 2024 at 4:56=E2=80=AFPM Murthy Nunna &lt;<a=
 href=3D"mailto:mnunna@fnal.gov">mnunna@fnal.gov</a>&gt; wrote:</span><br><=
/div></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" sty=
le=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddi=
ng-left:1ex"><div class=3D"msg4335564884166909135">


<div lang=3D"EN-US" style=3D"overflow-wrap: break-word;">
<div class=3D"m_4335564884166909135WordSection1">
<p class=3D"MsoNormal"><span style=3D"font-size:12pt">=C2=A0</span><br></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12pt">How can I rewrite the=
 above in psql</span></p></div></div></div></blockquote><div><br></div><div=
><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-ser=
if">The only real trick is using a psql variable instead of the shell-injec=
tion of the environment variable.=C2=A0 Use the --set CLI argument to assig=
n the environment variable to a psql variable then refer to it in the query=
 using :&#39;timout_mins&#39;</div><div class=3D"gmail_default" style=3D"fo=
nt-family:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_default=
" style=3D"font-family:arial,helvetica,sans-serif">Removing the limit 1 sho=
uld be as simple as not typing limit 1 when you bring the query into the ps=
ql script.</div><div class=3D"gmail_default" style=3D"font-family:arial,hel=
vetica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-fam=
ily:arial,helvetica,sans-serif">David J.</div></div><div class=3D"gmail_def=
ault" style=3D"font-family:arial,helvetica,sans-serif"><br></div></div></di=
v>

--000000000000a763eb061c75d25d--