Thread: How to Determine Number of connected users

How to Determine Number of connected users

From
Andrei Verovski (aka MacGuru)
Date:
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
*********************************************


Re: How to Determine Number of connected users

From
Rod Taylor
Date:
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.

Attachment