Received: from MAIL01.stbernard.com (mail01.stbernard.com [64.154.93.162]) by postgresql.org (Postfix) with ESMTP id 8E97D474E42; Fri, 29 Mar 2002 18:18:56 -0500 (EST) Received: by MAIL01.stbernard.com with Internet Mail Service (5.5.2653.19) id ; Fri, 29 Mar 2002 15:22:38 -0800 Message-ID: <7C760DAA511DC74B99E7D22189F786F1906DE4@MAIL01.stbernard.com> From: Jie Liang To: 'Bruce Momjian' , Jie Liang Cc: Tom Lane , "'admin-sql@postgresql.org'" , pgsql-sql@postgresql.org Subject: Re: system tables Date: Fri, 29 Mar 2002 15:22:37 -0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200203/390 X-Sequence-Number: 7264 no such one, it's very important to me, can you indecate one. Thanks. -----Original Message----- From: Bruce Momjian [mailto:pgman@candle.pha.pa.us] Sent: Friday, March 29, 2002 3:13 PM To: Jie Liang Cc: Tom Lane; 'admin-sql@postgresql.org'; pgsql-sql@postgresql.org Subject: Re: system tables 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