Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 495DA475D88 for ; Fri, 29 Mar 2002 19:27:56 -0500 (EST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 5AD16D602; Fri, 29 Mar 2002 16:27:44 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 466A95C02; Fri, 29 Mar 2002 16:27:44 -0800 (PST) Date: Fri, 29 Mar 2002 16:27:44 -0800 (PST) From: Stephan Szabo To: Jie Liang Cc: 'Bruce Momjian' , Tom Lane , Subject: Re: system tables In-Reply-To: <7C760DAA511DC74B99E7D22189F786F1906DE4@MAIL01.stbernard.com> Message-ID: <20020329162551.W58988-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200203/391 X-Sequence-Number: 7265 On Fri, 29 Mar 2002, Jie Liang wrote: > no such one, > it's very important to me, > can you indecate one. For 7.2, you probably can use pg_stat_activity (it's a view). In earlier versions, I don't think you have access to that info except via ps. > In psql, do \dS in psql. I think it is pg_activity something. > > Jie Liang wrote: > > Which system table holds such info as: > > login user, session pid ... ?