diff options
| author | Daniel Gustafsson <dgustafsson@postgresql.org> | 2025-03-25 17:53:33 +0100 |
|---|---|---|
| committer | Daniel Gustafsson <dgustafsson@postgresql.org> | 2025-03-25 17:53:33 +0100 |
| commit | 1a759c83278fcdae11ee5da8318b646b9d47129c (patch) | |
| tree | 6b61dad74bd7337ac9c950bb5343ee18c3915caa /doc/src | |
| parent | a19db082749662a933d0bf72722982b1ee2c4725 (diff) | |
| download | postgresql-1a759c83278fcdae11ee5da8318b646b9d47129c.tar.gz postgresql-1a759c83278fcdae11ee5da8318b646b9d47129c.zip | |
psql: Make default \watch interval configurable
The default interval for \watch to wait between executing queries,
when executed without a specified interval, was hardcoded to two
seconds. This adds the new variable WATCH_INTERVAL which is used
to set the default interval, making it configurable for the user.
This makes \watch the first command which has a user configurable
default setting.
Author: Daniel Gustafsson <daniel@yesql.se>
Reviewed-by: Heikki Linnakangas <hlinnaka@iki.fi>
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Reviewed-by: Kirill Reshke <reshkekirill@gmail.com>
Reviewed-by: Masahiro Ikeda <ikedamsh@oss.nttdata.com>
Reviewed-by: Laurenz Albe <laurenz.albe@cybertec.at>
Reviewed-by: Greg Sabino Mullane <htamfids@gmail.com>
Reviewed-by: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Discussion: https://postgr.es/m/B2FD26B4-8F64-4552-A603-5CC3DF1C7103@yesql.se
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index f083dba49a9..f7c8bc16a7f 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -3852,6 +3852,8 @@ SELECT 1 \bind \sendpipeline until interrupted, or the query fails, or the execution count limit (if given) is reached, or the query no longer returns the minimum number of rows. Wait the specified number of seconds (default 2) between executions. + The default wait can be changed with the variable + <xref linkend="app-psql-variables-watch-interval"/>). For backwards compatibility, <replaceable class="parameter">seconds</replaceable> can be specified with or without an <literal>interval=</literal> prefix. @@ -4746,6 +4748,17 @@ bar </listitem> </varlistentry> + <varlistentry id="app-psql-variables-watch-interval"> + <term><varname>WATCH_INTERVAL</varname></term> + <listitem> + <para> + This variable sets the default interval which <command>\watch</command> + waits between executing the query. Specifying an interval in the + command overrides this variable. + </para> + </listitem> + </varlistentry> + </variablelist> </refsect3> |