Discussion:
How can i know the users that are loged in
(too old to reply)
Vasilis Ventirozos
2003-12-10 12:01:42 UTC
Permalink
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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Antonis Antoniou
2003-12-10 15:58:05 UTC
Permalink
Post by Vasilis Ventirozos
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;




---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Loading...