Re: How to get information of active/inactive user

On Wed, 2003-03-19 at 10:59, Flower Sun wrote:
> Do you know what's the command to get information of active/inactive
> user connection(session) for postgresql?

I'm not sure what you mean by an "inactive user connection" -- but
presently connected clients can be viewed using either ps or the pg_stat
system views:

http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/monitoring.html

Cheers,

Neil