Обсуждение: users connected

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

users connected

От
"Cardoso Patrick"
Дата:

Hi,

 

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

 

            Regards

 

 

Re: users connected

От
Robert Treat
Дата:
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
Дата:
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