| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Murthy Nunna <mnunna(at)fnal(dot)gov>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Subject: | Re: psql help |
| Date: | 2024-07-05 04:25:25 |
| Message-ID: | 7d7aff89-cbf9-41da-8058-b7878817e22e@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lok P | 2024-07-05 05:07:16 | Re: Design strategy for table with many attributes |
| Previous Message | Murthy Nunna | 2024-07-05 03:54:56 | RE: psql help |