Received: from candle.pha.pa.us (216-55-132-35.dsl.san-diego.abac.net [216.55.132.35]) by postgresql.org (Postfix) with ESMTP id 220FB474E42; Fri, 29 Mar 2002 18:12:53 -0500 (EST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id g2TNCkQ16995; Fri, 29 Mar 2002 18:12:46 -0500 (EST) From: Bruce Momjian Message-Id: <200203292312.g2TNCkQ16995@candle.pha.pa.us> Subject: Re: system tables In-Reply-To: <7C760DAA511DC74B99E7D22189F786F1906DE3@MAIL01.stbernard.com> To: Jie Liang Date: Fri, 29 Mar 2002 18:12:46 -0500 (EST) Cc: Tom Lane , "'admin-sql@postgresql.org'" , pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL97 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200203/389 X-Sequence-Number: 7263 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 ... ? > > Jie Liang > Software Engineer > St. Bernard Software > 16882 W. Bernardo Dr. > San Diego, CA 92127 > Tel: 858-524-2134 > Fax:858-676-2228 > jie@stbernard.com > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026