Postgresql: How to repeat query as soon as finished?

Question

Let's say I have a query like so:

SELECT * FROM a WHERE a.Category = 'liquid' ORDER BY a.MeasurementTime DESC;

and I want to see the results coming into the database 'live'.

How can I write a query for Postresql which will repeat as soon as the query finishes?

Answer 1

You can use the \watch n command in the terminal to re-execute the query every n seconds.

Example:

postgre=# SELECT * FROM TABLE WHERE CONDITION
postgre=# \watch 5
-- now the "SELECT * FROM TABLE WHERE CONDITION" is re-executed every 5 seconds