oracle v$session equivalent in postgresql - Mailing list pgsql-sql

From
Subject oracle v$session equivalent in postgresql
Date
Msg-id 20041105152808.GAFG3261.fed1rmmtao07.cox.net@CYGNUS
Whole thread Raw
Responses Re: oracle v$session equivalent in postgresql
List 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

pgsql-sql by date:

Previous
From: Thomas F.O'Connell
Date:
Subject: Re: Help in stored procedure
Next
From: Tom Lane
Date:
Subject: Re: Delayed result from another connection