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
*********************************************


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: How to Determine Number of connected users

--=-AkxCPJ1nAHKm9pTosUVG
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

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

select * from pg_stat_activity;

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

--=-AkxCPJ1nAHKm9pTosUVG
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (FreeBSD)

iD8DBQA/HpyU6DETLow6vwwRArjjAJwKJGwqXAguRIdSqcFtQxWbn0ZkeACf eeBg
ctlOKg0t/MXYRZabiRL6m5E=
=nx2R
-----END PGP SIGNATURE-----

--=-AkxCPJ1nAHKm9pTosUVG--