Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id CA86D9FBFDE for ; Thu, 18 Oct 2007 14:47:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 38687-06 for ; Thu, 18 Oct 2007 14:47:11 -0300 (ADT) X-Greylist: delayed 00:05:02.503572 by SQLgrey-1.7.5 Received: from mout.perfora.net (mout.perfora.net [74.208.4.195]) by postgresql.org (Postfix) with ESMTP id BDE869FBFA6 for ; Thu, 18 Oct 2007 14:47:12 -0300 (ADT) Received: from sherrylyn ([74.92.66.5]) by mrelay.perfora.net (node=mrus0) with ESMTP (Nemesis) id 0MKp8S-1IiZNm3Q9U-0003L7; Thu, 18 Oct 2007 13:42:08 -0400 From: "Sherrylyn\(Work\)" To: Subject: Date: Thu, 18 Oct 2007 13:42:06 -0400 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Importance: Normal X-Provags-ID: V01U2FsdGVkX1/ILVNZySXxksqMhCAdOyzyK6eKwrpjplJmecl 0YVi0RSRk0OCZMUN6Pl/mV653k958NaOcWGKW1Yy62yYyho8Xo 0Z8dspuOV3NoIlQ4Vwo8U+nOHZCl3lU X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.763 tagged_above=0 required=5 tests=BAYES_50=0.001, MISSING_SUBJECT=1.762 X-Spam-Level: * X-Archive-Number: 200710/177 X-Sequence-Number: 27091 Hi , Does any one know how I would get a list of users currently connected to a postgres database? In Oracle, I could select from the vg$sessions table. Is there a corollary table in Postgres?