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

How can i know the users that are loged in

From
Vasilis Ventirozos
Date:
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


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

From
Antonis Antoniou
Date:

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;