Thread: users connected

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

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