Allow default \watch interval in psql to be configured

Daniel Gustafsson <daniel@yesql.se>

From: Daniel Gustafsson <daniel@yesql.se>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2024-10-09T13:08:52Z
Lists: pgsql-hackers

Attachments

Scratching an old itch; I've long wanted to be able to set the default interval
for \watch in psql since I almost never want a 2 second wait.  The interval can
of course be set by passing it to \watch but it's handy during testing and
debugging to save that with just quick \watch.

The attached adds a new variable, WATCH_INTERVAL, which is used as the default
value in case no value is defined when executing the command.  The defualt of
this remains at 2 seconds as it is now.  The count and min_rows values are not
affected by this as those seem less meaningful to set defaults on.

--
Daniel Gustafsson

Commits

  1. psql: Fix incorrect equality comparison

  2. psql: Make test robust against locale variations

  3. psql: Make default \watch interval configurable