Re: [GENERAL] any way to query for current connections to db?

[volunteer]

select
 *
from
 pg_stat_activity
where
 datname = (
 select
  *
 from
  current_database()
 );

-------- Original Message --------
Subject: [GENERAL] any way to query for current connections to db?
From: "Coarr, Matt" <[EMAIL PROTECTED]>
Date: Fri, November 09, 2007 5:36 pm
To: <pgsql-general@postgresql.org>

Hi,
 
Is there any way to query the database to identify what the current
connections are (connections, sessions, or whatever you want to call
them)?
 
This would be something similar to oracle's v$session view.
 
Thanks,
Matt


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly