On Nov 9, 2007 4:36 PM, Coarr, Matt <mcoarr(at)mitre(dot)org> wrote:
>
> 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.
select * from pg_stat_activity where datname='mydbname'
should get you started.
You can see all the system tables with
\dS
in psql