Re: users connected

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Cardoso Patrick <cardoso(at)iut-rodez(dot)fr>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: users connected
Date: 2004-07-19 21:26:50
Message-ID: 1090272411.2711.48.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, 2004-07-16 at 10:42, Cardoso Patrick wrote:
> Hi,
>
> Is it possible to know the number of users connected to a
> database ?
>
> Regards
>
>

select * from pg_stat_activity;

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2004-07-19 21:31:55 Re: users connected
Previous Message Tom Lane 2004-07-19 21:24:06 Re: [HACKERS] Point in Time Recovery