Em Dom, 2005-08-28 às 14:37 +0200, Kretschmer Andreas escreveu:
> watch "echo \"SELECT * FROM pg_stat_activity;\" | psql -U <user> <db>
After I did it I receive a prompt like this
[flavio(at)localhost flavio]$ watch "echo \"SELECT * FROM pg_stat_activity;
\" | psql -U postgres template1
>
>
Can you help me more? Exist another way to run this query inside of psql
without using "watch"?
Thanks