Postgres Pro
Downloads
Home   >   mailing lists

Re: users connected - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: users connected
Date
Msg-id 40FC3DCB.2010706@bigfoot.com
Whole thread Raw
In response to users connected  ("Cardoso Patrick" <cardoso@iut-rodez.fr>)
List pgsql-admin
Tree view 
Cardoso Patrick wrote:
> Hi,
>
>
>
>  Is it possible to know the number of users connected to a database ?

select * from pg_stat_activity.

I'm not sure about permissions you need for it, try.



Regards
Gaetano Mendola

pgsql-admin by date:

Previous
From: Robert Treat
Date:
Subject: Re: users connected
Next
From: "Nigel Bishop"
Date:
Subject: Error in logfile on DB startup