Re: system tables - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: system tables
Date
Msg-id 20020329162551.W58988-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: system tables  (Jie Liang <jie@stbernard.com>)
List pgsql-sql
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 ... ?



pgsql-sql by date:

Previous
From: Jie Liang
Date:
Subject: Re: system tables
Next
From: "Hunter, Ray"
Date:
Subject: Statistics