pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
How to Determine Number of connected users
2+ messages / 2 participants
[nested] [flat]

* How to Determine Number of connected users
@ 2003-07-23 14:27  Andrei Verovski (aka MacGuru) <andreil1@mail.starlett.lv>
  0 siblings, 1 reply; 2+ messages in thread

From: Andrei Verovski (aka MacGuru) @ 2003-07-23 14:27 UTC (permalink / raw)
  To: pgsql-php

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: How to Determine Number of connected users
@ 2003-07-23 14:32  Rod Taylor <rbt@rbt.ca>
  parent: Andrei Verovski (aka MacGuru) <andreil1@mail.starlett.lv>
  0 siblings, 0 replies; 2+ messages in thread

From: Rod Taylor @ 2003-07-23 14:32 UTC (permalink / raw)
  To: Andrei Verovski <andreil1@mail.starlett.lv>; +Cc: 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.

Attachments:

  signature.asc (application/pgp-signature, 186B) download

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2003-07-23 14:32 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-07-23 14:27 How to Determine Number of connected users Andrei Verovski (aka MacGuru) <andreil1@mail.starlett.lv>
2003-07-23 14:32 ` Rod Taylor <rbt@rbt.ca>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox