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;