[SQL] oracle v$session equivalent in postgresql

[stuff]

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

[SQL] oracle v$session equivalent in postgresql

[stuff]

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');