oracle v$session equivalent in postgresql

From: <stuff(at)opensourceonline(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: oracle v$session equivalent in postgresql
Date: 2004-11-05 15:27:58
Message-ID: 20041105152808.GAFG3261.fed1rmmtao07.cox.net@CYGNUS
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I'm looking for the equivalent in postgresql to the v$session variables in
Oracle. In particular, I need to convert the following statement:

select s.program, s.machine into :New.app_name,:New.comp_name from v$session
s where s.audsid=userenv('SESSIONID');

Any help appreciated

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-11-05 15:53:55 Re: Delayed result from another connection
Previous Message Thomas F.O'Connell 2004-11-05 15:13:31 Re: Help in stored procedure