users connected

Поиск
Список
Период
Сортировка
Искать

users connected

От:
"Cardoso Patrick" <cardoso@iut-rodez.fr>
Дата:

Hi,

 

            Is it possible to know the number of users connected to a database ?

 

            Regards

 

 

Re: users connected

От:
Robert Treat <xzilla@users.sourceforge.net>
Дата:
On Fri, 2004-07-16 at 10:42, Cardoso Patrick wrote:
> Hi,
>  
>             Is it possible to know the number of users connected to a
> database ?
>  
>             Regards
>  
>  

select * from pg_stat_activity;

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Re: users connected

От:
Gaetano Mendola <mendola@bigfoot.com>
Дата:
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



FAQ