Re: How to Determine Number of connected users

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Andrei Verovski <andreil1(at)mail(dot)starlett(dot)lv>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: How to Determine Number of connected users
Date: 2003-07-23 14:32:53
Message-ID: 1058970772.48936.13.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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.

In response to

Browse pgsql-php by date

  From Date Subject
Next Message Lynna Landstreet 2003-07-23 21:49:54 Getting the year from a date column
Previous Message Andrei Verovski (aka MacGuru) 2003-07-23 14:27:26 How to Determine Number of connected users