TOP SESSIONS?

hi,

in oracle you would use these two cursors to determine who was
connected and

what they were doing.

select distinct s.sid sid, s.serial# serial, s.status status, osuser,
spid ,

count(o.sid) counter, s.username username, s.program
program, sql_address

from v$session s, v$open_cursor o, v$process p

where s.sid = o.sid(+)

and paddr = addr

group by s.sid,s.serial#, s.status , osuser, spid ,s.username,
s.program ,sql_address

order by 1,3

select distinct name

from sys.audit_actions, v$sqltext

where address = ?

and action = command_type

<bold><color><param>0000,0000,8080</param><bigger>does anyone know what
tables in postgres would give me the same or similar information?

</bigger></color></bold>TIA,

mikeo