Thread: system tables
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
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, Pennsylvania19026
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, Pennsylvania19026
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 ... ?