Thread: oracle v$session equivalent in postgresql

oracle v$session equivalent in postgresql

From
Date:
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I’m looking for the equivalent in postgresql to the v$session variables in Oracle. In particular, I
needto convert the following statement:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">select s.program, s.machine into :New.app_name,:New.comp_name from v$session s where
s.audsid=userenv('SESSIONID');</span></font></div>