[SQL] oracle v$session equivalent in postgresql

2004-11-07 Thread 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');

[SQL] oracle v$session equivalent in postgresql

2004-11-05 Thread 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