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/st
Dhimant Patel 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_st
