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 E8B1B3A3CAE for ; Fri, 5 Nov 2004 15:28: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 49126-04 for ; Fri, 5 Nov 2004 15:28:05 +0000 (GMT) Received: from fed1rmmtao07.cox.net (fed1rmmtao07.cox.net [68.230.241.32]) by svr1.postgresql.org (Postfix) with ESMTP id 20FAE3A3CA3 for ; Fri, 5 Nov 2004 15:28:07 +0000 (GMT) Received: from CYGNUS ([68.228.61.13]) by fed1rmmtao07.cox.net (InterMail vM.6.01.04.00 201-2131-117-20041022) with ESMTP id <20041105152808.GAFG3261.fed1rmmtao07.cox.net@CYGNUS> for ; Fri, 5 Nov 2004 10:28:08 -0500 From: To: Subject: oracle v$session equivalent in postgresql Date: Fri, 5 Nov 2004 08:27:58 -0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0011_01C4C311.5DA87D00" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcTB4Imzz2To28ktS6WOk5Mfj4uUhQBa2rgw Message-Id: <20041105152808.GAFG3261.fed1rmmtao07.cox.net@CYGNUS> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_60_70, HTML_FONTCOLOR_UNKNOWN, HTML_MESSAGE, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200411/46 X-Sequence-Number: 19365 This is a multi-part message in MIME format. ------=_NextPart_000_0011_01C4C311.5DA87D00 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'); Any help appreciated ------=_NextPart_000_0011_01C4C311.5DA87D00 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');

Any help = appreciated

------=_NextPart_000_0011_01C4C311.5DA87D00--