Re: I want to find out who is using a database

[Shoaib Mir <shoaibmir@xxxxxxxxx>]

On Wed, Nov 10, 2010 at 1:17 PM, Tena Sakai <tsakai@xxxxxxxxxxxxxx> wrote:

Can somebody please tell me how I find who it is using the
xxxxx database?

select * from pg_stat_activity where datname = '<yourdbname>'; 

-- 
Shoaib Mir
http://shoaibmir.wordpress.com/