How can I see which users are connected?

From: "Jacob Vennervald Madsen" <jvm(at)gopinocchio(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How can I see which users are connected?
Date: 2002-03-11 10:18:01
Message-ID: EB0B5D39043C344BA53B0F4AB15AE633029943@gop-server.GOP-server.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi List

I'm trying to drop a database but I get this error:
ERROR: DROP DATABASE: database "mydb" is being accessed by other users

How can I see which user that is and from where he is connected?

Jacob

Responses

Browse pgsql-general by date

  From Date Subject
Next Message adm 2002-03-11 10:20:53 Please help me!!!
Previous Message joerg.naumann 2002-03-11 10:12:37 error can't select an agregate function