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