Thread: How can i know the users that are loged in

Hi all i want to ask something about user managment ,

How can i know the users that
are loged thru an SQL command
or how can i know who i am (my username) thru SQL again

i can see that the users are loging so when i connect to a database
a triger (maybe) raises an notise that user vasilis is loged in


Thanx in advance

Vasilis Ventirozos

Vasilis Ventirozos wrote:

>Hi all i want to ask something about user managment ,
>
>How can i know the users that
>are loged thru an SQL command
>or how can i know who i am (my username) thru SQL again
>
>i can see that the users are loging so when i connect to a database
>a triger (maybe) raises an notise that user vasilis is loged in
>

If I understood correctly you need the query below:
SELECT * from pg_stat_activity;