public inbox for [email protected]
help / color / mirror / Atom feedFrom: Edwin UY <[email protected]>
To: David G. Johnston <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: \i and \watch
Date: Thu, 7 Nov 2024 20:49:56 +1300
Message-ID: <CA+wokJ_nqFaPF8YaLsgndawVT-Wf-Zw5hBaK5=F8UehD2PozXQ@mail.gmail.com> (raw)
In-Reply-To: <CAKFQuwZvMkCNffV8_X2yeVFJdOaFKwVUEuWcLpsvP-w+YjwBGw@mail.gmail.com>
References: <CA+wokJ-NAMMVdo52WdwmGN8CasaE026jhRH7yb1MFU2eF=HeEw@mail.gmail.com>
<CAKFQuwZvMkCNffV8_X2yeVFJdOaFKwVUEuWcLpsvP-w+YjwBGw@mail.gmail.com>
Thanks for the explanation.
Yeah, here's what's happening. So, yeah, we'll check on having to script it
instead.
###
=> select now() ;
now
-------------------------------
2024-11-07 07:46:23.876888+00
(1 row)
=> \! cat x.sql
select version() ;
=> \i x.sql
version
--------------------------------------------------------------------------------------------------------------
PostgreSQL 14.12 on aarch64-unknown-linux-gnu, compiled by
aarch64-unknown-linux-gnu-gcc (GCC) 9.5.0, 64-bit
(1 row)
=> \watch 5
Thu 07 Nov 2024 20:47:05 NZDT (every 5s)
now
-------------------------------
2024-11-07 07:47:05.411747+00
(1 row)
Thu 07 Nov 2024 20:47:10 NZDT (every 5s)
now
-------------------------------
2024-11-07 07:47:10.418915+00
(1 row)
^C
On Thu, Nov 7, 2024 at 6:26 PM David G. Johnston <[email protected]>
wrote:
> On Wednesday, November 6, 2024, Edwin UY <[email protected]> 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.
>
>
view thread (4+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: \i and \watch
In-Reply-To: <CA+wokJ_nqFaPF8YaLsgndawVT-Wf-Zw5hBaK5=F8UehD2PozXQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox