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@seznam.cz
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>