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

From
Subject oracle v$session equivalent in postgresql
Date
Msg-id 20041103200604.HPOR22960.fed1rmmtao06.cox.net@CYGNUS
Whole thread Raw
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');

pgsql-sql by date:

Previous
From: jcelko212@earthlink.net (--CELKO--)
Date:
Subject: third edition of SQL FOR SMARTIES
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: query using a date field that isn't set