Обсуждение: Calls to find Users and databases open...

What are the SQL commands to find who is logged on a server, what database
he/she has open, etc?

Where is this information in the help file or documentation?

Thanks,
Thomas

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar � get it now!
http://toolbar.msn.com/go/onm00200415ave/direct/01/

El Vie 30 Abr 2004 11:16, Thomas LeBlanc escribió:
> What are the SQL commands to find who is logged on a server, what database
> he/she has open, etc?
>
> Where is this information in the help file or documentation?

select * from pg_stat_activity;

--
 11:47:01 up 1 day, 17:09,  3 users,  load average: 0.21, 0.65, 0.89
-----------------------------------------------------------------
Martín Marqués        | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica  |  DBA, Programador, Administrador
             Universidad Nacional
                  del Litoral
-----------------------------------------------------------------