Re: who is connected to the database ?? - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: who is connected to the database ??
Date
Msg-id 20060103181107.GA2222@kaufbach.delug.de
Whole thread Raw
In response to who is connected to the database ??  (Hugo <htakada@gmail.com>)
List pgsql-general
Hugo <htakada@gmail.com> schrieb:

> hello , is there a way to answer that question ?

Try this:

select * from pg_stat_activity ;


But some fields are only available with 8.1.

> thanks in advance

Please, no HTML.


HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: generic way to retrieve array as rowset
Next
From: Andreas Kretschmer
Date:
Subject: Re: generic way to retrieve array as rowset