Re: List of currently connected users

ps -ef | grep post

postgres 4571 27462 0 12:02 ? 00:00:00 postgres: medi Test1
[local] idl

says, some guy name 'medi' is connected to database 'Test1' via process
ID 4571.

or

psql -c "select * from pg_stat_activitity"

datid | datname | procpid | usesysid | usename | current_query
-------+---------+---------+----------+---------+---------------
16556 | Test1 | 4571 | 100 | medi |
(1 row)

Which says some guy named 'medi' is connecting to database 'Test1' via
process ID 4571.

Isn't PG cool....

juleni wrote:

>Hello,
> Is it possible to show a list of all currently connected users into the
>specific postgres database (what's the command)?
>
> Thanks,
> Julian
>
>mailto:juleni(at)seznam(dot)cz
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>