Thread: How to Determine Number of connected users

Hi,

Is it possible to determine number of connected users to certain
PostgreSQL database from within PHP script?

Thanks in advance for any suggestion.

*********************************************
*   Best Regards   ---   Andrei Verovski
*
*   Personal Home Page
*   http://snow.prohosting.com/guru4mac
*   Mac, Linux, DTP, Development, IT WEB Site
*********************************************

On Wed, 2003-07-23 at 10:27, Andrei Verovski wrote:
> Hi,
>
> Is it possible to determine number of connected users to certain
> PostgreSQL database from within PHP script?

select * from pg_stat_activity;

Add the appropriate where clause for whatever you are trying to restrict
by.