checking session status - Mailing list pgsql-admin

From s.chava@wcom.com (Srinivasa Rao Chava)
Subject checking session status
Date
Msg-id 66d229f1.0203111407.62ff5dff@posting.google.com
Whole thread Raw
List pgsql-admin
Hi,
How to check the session status in postgresql.Say, I want to check who
is logged in to the database at the moment. In ,oracle , I use v$session view
which gives the users logged in to the database. But I don't know how
to do it postgresql. With ps -ef | grep postmaster* command , I can know
how many postgres processes are running. But How to know which process
belong to which database user account.
Thanks for any help
chava

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: News server broken ?
Next
From: "Adam Wyard"
Date:
Subject: Update 6.5 database files to 7.0