Home >PostgreSQL > postgres tip: how re-execute a query every n second



The PostgreSQL command \watch n it is very handy when you want to update query results every n seconds, and it is very easy to use. For example, If I want to keep an eye on the total of rows on my transaction table every 5 seconds:

---

---

Warning: include(ads/text468x15.html): failed to open stream: No such file or directory in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131

Warning: include(): Failed opening 'ads/text468x15.html' for inclusion (include_path='.;C:\php\pear') in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131

Tutorial
PostgreSQL determine database uptime   [PostgreSQL] 
Postgres check database is Master or Replica ways to check database replication role  [PostgreSQL] 
Ordering by highest or lowest value of multiple columns PostgreSQL functions in order by clause  [PostgreSQL] 
Posgresql how disable and renable foreign constraints forcing data into a table ignoring foreign keys (or trigger)  [PostgreSQL] 
Comandi
date and timestamp simple Using date and timestamp   [PostgreSQL] 
Add time to a date date function operation  [PostgreSQL] 
How set a default schema working away in your postgreSQL session  [PostgreSQL] 
postgres tip: how re-execute a query every n second a nice postgres shell command  [PostgreSQL] 
Grouping data by the week example date_trunc function, trimming days by the week  [PostgreSQL] 
How get PosgreSQL table size pg_total_relation_size function  [PostgreSQL] 
PostgreSQL determine database size pg_database_size function returns database size   [PostgreSQL] 
PostgreSQL enable autostart at reboot on Centos / Redhat Configure autostart after reboot  [PostgreSQL] 

---

---