On 7/4/24 20:54, Murthy Nunna wrote:
> Sorry, there is no problem with the following statement and the
> environment variable. It works fine. But it terminates only one PID due
> to LIMIT 1. I want to terminate all pids that meet this criteria. If I
> remove LIMIT 1, pg_terminate_backend(pid) will not work as it expects
> only one pid at a time. So, the question is how to rewrite this psql so
> it loops through all pids one pid at a time? Thanks in advance for your
> help.
From here:
https://www.postgresql.org/docs/current/app-psql.html
See:
\gexec
--
Adrian Klaver
adrian.klaver@aklaver.com