Re: Currently connected users...

Dhimant Patel <drp4kri(at)gmail(dot)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°