[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