Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 050336443CE for ; Mon, 15 Mar 2010 18:04:38 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 25857-06-5 for ; Mon, 15 Mar 2010 21:04:27 +0000 (UTC) Received: from mx1.hub.org (mx1.hub.org [200.46.208.106]) by mail.postgresql.org (Postfix) with ESMTP id A233E659E2F for ; Mon, 15 Mar 2010 17:50:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.fmed.uba.ar (mail.fmed.uba.ar [157.92.152.1]) by mx1.hub.org (Postfix) with ESMTP id 4E1023267F10 for ; Mon, 15 Mar 2010 17:50:08 -0300 (ADT) Received: from [157.92.152.105] (unknown [157.92.152.105]) by mail.fmed.uba.ar (Postfix) with ESMTP id E686839D17B; Mon, 15 Mar 2010 17:48:07 -0200 (ARST) Message-ID: <4B9E9B54.1040306@fmed.uba.ar> Date: Mon, 15 Mar 2010 17:40:52 -0300 From: Gerardo Herzig User-Agent: Thunderbird 2.0.0.6 (X11/20070801) MIME-Version: 1.0 To: John Dizaro CC: pgsql-sql@postgresql.org Subject: Re: I, nead to capture the IP number from the PC how is running the script ... References: <11c2d5211003151218y4ce9218du20034785a8103c39@mail.gmail.com> In-Reply-To: <11c2d5211003151218y4ce9218du20034785a8103c39@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/91 X-Sequence-Number: 33798 John Dizaro wrote: > I, nead to capture the IP number from the PC how is running the script > "update TABLE1 set campo1 = 123 where ...; " > Can someone help me please? > > the pg_stat_activity view has a column named client_addr and a current_query column. That should help. Gerardo