Re: see all queries incoming - Mailing list pgsql-novice

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@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