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');
On Fri, 5 Nov 2004 08:27:58 -0700, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
>
> 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 fro
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
