Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t8uo1-006iJu-Hj for pgsql-admin@arkaria.postgresql.org; Thu, 07 Nov 2024 05:11:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t8umz-00Bwyv-E6 for pgsql-admin@arkaria.postgresql.org; Thu, 07 Nov 2024 05:10:38 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t8umz-00Bwyn-1i for pgsql-admin@lists.postgresql.org; Thu, 07 Nov 2024 05:10:37 +0000 Received: from mail-pl1-x633.google.com ([2607:f8b0:4864:20::633]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t8umv-000cpd-Fo for pgsql-admin@lists.postgresql.org; Thu, 07 Nov 2024 05:10:36 +0000 Received: by mail-pl1-x633.google.com with SMTP id d9443c01a7336-20c8c50fdd9so12011245ad.0 for ; Wed, 06 Nov 2024 21:10:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1730956232; x=1731561032; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=+oNqPx61mNvhypMOl9sGsXs1tXe8G7OovGApM34vRow=; b=hm+O7MXU5+hqAQqEAOri8V5Kp98muuyS9rkDP2iohqib/Ns3u9H2dOir081pnpqevW Zl1fmDYEuDalfi/iQgAAugT3cd8KUEe/R63O6WEzZk1dLYfGOWnQU/N+li87akcNSPSz MgMA36V6ouxCeRIaauBrYdDRVpXECfYTcpHc8tfid27//dc3dIWoMJsfWRxz2wbzJyLF be5ykrwGV97jjG7qHUiEBomTqQMFnkDl/CEqtVycdnQVqMQtf8b9zGA8J/PkmoVUIDiu JOLfING98F8xbJGedPAUx/p375bK85K5IkXR7e/c8vV4CZnWSSVgWoyaHXfiN4DqWQmN Azqg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1730956232; x=1731561032; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=+oNqPx61mNvhypMOl9sGsXs1tXe8G7OovGApM34vRow=; b=NqIpz2wV7zCPODEBbjCZ3e2sWVYlYie66qGs4heCz58ikhE7KiPUYtgOb28Bog26s6 zVkLrkkda/sNnSGq9mjSgHJ/nSHfJgzLPe/ezf0hsburoPiubKaLFZD9yXv0MEU/pF/d P3gm9ETCzX1/CAepCR5msX33oKLCtdOWfLLeyfQH03cgKiFlGW+OfHnorwp/HhiJ+aFK eF+1Sn2nlkDQYrvFFTKgvEkgvUDz9YsxsUUvyhdhEcKlRg2ZcQkwieey+6r4hY0pyDe/ Qp2BNLiSFdSBZnTxo1D2xTSc7uH6Q01sg5FgyUDkO1POBRtcXt6E4ZroMWYj9y1yCqgi oCOA== X-Gm-Message-State: AOJu0YySWYuoqIM3XHn5lo0L5apjwbVvSpFhvvNrt5gfgRHVHD2zgv6n sDwmHvrMT3iIfoLkl8zL64ZcdC/4zoZiGjO5veOIxpU3/z9dovu7vH657WbUepTZ4vDtnt7P5tu pPWSk10HlHN13FpwmDMQNEWVm35+oMuEf X-Google-Smtp-Source: AGHT+IEFPbuWi6znPBAqR4QfUYKEQ2yr8gDQDE4oqFw3thbPI5K5gM57ZdkawyPwmYSMxs+QNGPF3JAK6L2tNtSThrs= X-Received: by 2002:a17:902:d50a:b0:211:6e93:9e5f with SMTP id d9443c01a7336-21175b17f7dmr37840935ad.22.1730956231977; Wed, 06 Nov 2024 21:10:31 -0800 (PST) MIME-Version: 1.0 From: Edwin UY Date: Thu, 7 Nov 2024 18:09:55 +1300 Message-ID: Subject: \i and \watch To: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000054384606264ba7e6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000054384606264ba7e6 Content-Type: text/plain; charset="UTF-8" Hi, 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. At the moment, a workaround is I run the content of x.sql itself and then run watch. Please advise. Thanks. Regards, Ed --00000000000054384606264ba7e6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

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= .

At the moment, a workaround is I run the content= of x.sql itself and then run watch.
Please advise. Thanks.<= br>

Regards,
Ed

--00000000000054384606264ba7e6--