Re: system tables - Mailing list pgsql-sql

From Jie Liang
Subject Re: system tables
Date
Msg-id 7C760DAA511DC74B99E7D22189F786F1906DE4@MAIL01.stbernard.com
Whole thread Raw
In response to system tables  (Jie Liang <jie@stbernard.com>)
Responses Re: system tables
List pgsql-sql
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
 


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: system tables
Next
From: Stephan Szabo
Date:
Subject: Re: system tables