Re: Anyway to know which users are connected to postgres?

"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