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

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

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.

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