Currently connected users...

Dhimant Patel, 21.01.2010 17:40:

I'm a beginner Postgres user, and need quick hint from someone.

How could I know which users are currently connected to postgres instance?

http://www.postgresql.org/docs/current/static/monitoring.html

More precisely:
http://www.postgresql.org/docs/current/static/monitoring-stats.html#MONITORING-STATS-VIEWS

Thomas

Dhimant Patel <drp4kri@gmail.com> wrote:

I'm a beginner Postgres user, and need quick hint from someone.

How could I know which users are currently connected to postgres instance?

You can use pg_stat_activity:

select * from pg_stat_activity

Or, if you need only the usernames:

select usename from pg_stat_activity ;

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082�, E 13.56889�