oracle v$session equivalent in postgresql

From: <stuff(at)opensourceonline(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: oracle v$session equivalent in postgresql
Date: 2004-11-03 20:06:00
Message-ID: 20041103200604.HPOR22960.fed1rmmtao06.cox.net@CYGNUS
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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');

Browse pgsql-sql by date

  From Date Subject
Next Message sad 2004-11-04 06:30:43 Re: CREATE TYPE
Previous Message Greg Stark 2004-11-03 19:20:32 Re: vacuum analyze slows sql query