X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 74E633A3AE2 for ; Wed, 3 Nov 2004 20:06:18 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 73553-06 for ; Wed, 3 Nov 2004 20:06:08 +0000 (GMT) Received: from fed1rmmtao06.cox.net (fed1rmmtao06.cox.net [68.230.241.33]) by svr1.postgresql.org (Postfix) with ESMTP id 3EE6A3A2B1B for ; Wed, 3 Nov 2004 20:06:08 +0000 (GMT) Received: from CYGNUS ([68.228.61.13]) by fed1rmmtao06.cox.net (InterMail vM.6.01.04.00 201-2131-117-20041022) with ESMTP id <20041103200604.HPOR22960.fed1rmmtao06.cox.net@CYGNUS> for ; Wed, 3 Nov 2004 15:06:04 -0500 From: To: Subject: oracle v$session equivalent in postgresql Date: Wed, 3 Nov 2004 13:06:00 -0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001F_01C4C1A5.DDE19690" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcTB4Imzz2To28ktS6WOk5Mfj4uUhQ== Message-Id: <20041103200604.HPOR22960.fed1rmmtao06.cox.net@CYGNUS> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.4 tagged_above=0.0 required=5.0 tests=HTML_60_70, HTML_MESSAGE, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200411/59 X-Sequence-Number: 19378 This is a multi-part message in MIME format. ------=_NextPart_000_001F_01C4C1A5.DDE19690 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit 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'); ------=_NextPart_000_001F_01C4C1A5.DDE19690 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

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=3Duserenv('SESSIONID');

------=_NextPart_000_001F_01C4C1A5.DDE19690--