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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
