On Thu, Jul 4, 2024 at 4:56 PM Murthy Nunna <mnunna(at)fnal(dot)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.