From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Edwin UY <edwin(dot)uy(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: \i and \watch |
Date: | 2024-11-07 05:26:53 |
Message-ID: | CAKFQuwZvMkCNffV8_X2yeVFJdOaFKwVUEuWcLpsvP-w+YjwBGw@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Wednesday, November 6, 2024, Edwin UY <edwin(dot)uy(at)gmail(dot)com> wrote:
>
> Is there no way to use \watch to let it run the last script that I just
> run?
>
> When do I do as below:
>
> select 1 ;
> \i x.sql
> \watch 20
>
> It runs select 1 instead.
>
>
Watch is documented to act on either a non-empty query buffer or the last
sent command. I would expect that whatever the final SQL command present
in x.sql is would be the command that gets watched. If indeed the
preceding select 1 command is watched there would seem to be an
undocumented interaction going on.
In any case, no, you cannot watch a meta-command. You’d have to resort to
shell scripting the repeated execution of the psql program itself.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Edwin UY | 2024-11-07 07:49:56 | Re: \i and \watch |
Previous Message | Edwin UY | 2024-11-07 05:09:55 | \i and \watch |