Thread: who is connected to the database ??

hello , is there a way to answer that question ?


thanks in advance

Hugo

Pd.

Postgres 8.1 on FC4 and WinXP Pro

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°