Tom Lane wrote:
> "Peter E. Chen" <pchen3@jhmi.edu> writes:
>
>>I'd like to know if there is anyway one can figure out who is currently
>>connected to the database.
>>
>
> In 7.2 there is a system view pg_stat_activity.
>
> Since about 7.0, a "ps" listing will show the owning user for each
> postgres backend process (on most platforms, anyway).
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
This is very nice. I can't ever see the current query, however,
even as postgres. Is this column just to tease us? I can
see it could be a security issue.
elein
--
--------------------------------------------------------
elein@nextbus.com
(510)420-3120
www.nextbus.com
spinning to infinity, hallelujah
--------------------------------------------------------