MIME-Version: 1.0
In-Reply-To: 
 <CA+wokJ-NAMMVdo52WdwmGN8CasaE026jhRH7yb1MFU2eF=HeEw@mail.gmail.com>
References: 
 <CA+wokJ-NAMMVdo52WdwmGN8CasaE026jhRH7yb1MFU2eF=HeEw@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 6 Nov 2024 22:26:53 -0700
Message-ID: 
 <CAKFQuwZvMkCNffV8_X2yeVFJdOaFKwVUEuWcLpsvP-w+YjwBGw@mail.gmail.com>
Subject: Re: \i and \watch
To: Edwin UY <edwin.uy@gmail.com>
Cc: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e0008906264be17a"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwZvMkCNffV8_X2yeVFJdOaFKwVUEuWcLpsvP-w%2BYjwBGw%40mail.gmail.com>
Precedence: bulk

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

On Wednesday, November 6, 2024, Edwin UY <edwin.uy@gmail.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=E2=80=99d have to re=
sort to
shell scripting the repeated execution of the psql program itself.

David J.

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

On Wednesday, November 6, 2024, Edwin UY &lt;<a href=3D"mailto:edwin.uy@gma=
il.com">edwin.uy@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail_quo=
te" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"=
><div dir=3D"ltr"><div><br></div><div>Is there no way to use \watch to let =
it run the last script that I just run?</div><div><br></div><div>When do I =
do as below:</div><div><br></div><div>select 1 ;</div><div>\i x.sql</div><d=
iv>\watch 20</div><div><br></div><div>It runs select 1 instead.</div><div><=
br></div></div></blockquote><div><br></div><div>Watch is documented to act =
on either a non-empty query buffer or the last sent command.=C2=A0 I would =
expect that whatever the final SQL command present in x.sql is would be the=
 command that gets watched.=C2=A0 If indeed the preceding select 1 command =
is watched there would seem to be an undocumented interaction going on.</di=
v><div><br></div><div>In any case, no, you cannot watch a meta-command.=C2=
=A0 You=E2=80=99d have to resort to shell scripting the repeated execution =
of the psql program itself.</div><div><br></div><div>David J.</div><div><br=
></div>

--000000000000e0008906264be17a--