Viewing current connection(s) in PostgreSQL queries

How to view current connections in postgres Server ?
The following link contains information about this .


http://chrismiles.info/systemsadmin/databases/articles/viewing-current-postgresql-queries/

With newer versions of PostgreSQL we get some more details. Here's an example I've used on PostgreSQL 8.2:

SELECT datname,usename,procpid,client_addr,waiting,query_start,current_query FROM pg_stat_activity ;