Is there a way to kill a connection from the pg_stat_activitly list?

When you see a hanging Postgres connection (or a job running so long and you don't want to continue any more) from

select * from pg_stat_activity

and you want to disconnect it,

how do you do it?

thanks,
Jessica

---

Check out the hottest 2008 models today at Yahoo! Autos.