Hi, you could use "select usename from pg_stat_activity;"
PS. this is an english-speaking list, so for the future please write your mails in english. Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 >>> On Mon, Nov 12, 2007 at 2:42 PM, in message <[EMAIL PROTECTED]>, "Cristiano Panvel" <[EMAIL PROTECTED]> wrote: > Oi Rapazeada, > > Existe alguma função do PostgreSQL para eu listar os usúarios que > estão conectados > ao banco, minha aplicação autentica com os usúarios diretamente do banco. > > Cris > > --------------------------- (end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
