users connected

[Gaetano Mendola]

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




---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Robert Treat]

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

select * from pg_stat_activity;

Robert Treat