On Fri, 29 Mar 2002, Jie Liang wrote:
> no such one,
> it's very important to me,
> can you indecate one.
For 7.2, you probably can use
pg_stat_activity (it's a view).
In earlier versions, I don't think you
have access to that info except via
ps.
> In psql, do \dS in psql. I think it is pg_activity something.
>
> Jie Liang wrote:
> > Which system table holds such info as:
> > login user, session pid ... ?