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

[Tena Sakai <tsakai@xxxxxxxxxxxxxx>]

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

Thank you, Shoaib.

Tena


On 11/9/10 6:26 PM, "Shoaib Mir" <shoaibmir@xxxxxxxxx> wrote:

> 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>';