Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 1B835644239 for ; Mon, 15 Mar 2010 18:01:02 -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 25417-02-7 for ; Mon, 15 Mar 2010 21:00:51 +0000 (UTC) Received: from mx2.hub.org (mx2.hub.org [200.46.204.254]) by mail.postgresql.org (Postfix) with ESMTP id 8BE0A65B145 for ; Mon, 15 Mar 2010 17:36:56 -0300 (ADT) X-Greylist: delayed 00:58:10.366897 by SQLgrey-1.7.6 Received: from mail.codecraft.se (unknown [84.19.136.41]) by mx2.hub.org (Postfix) with ESMTP id 224C01E809D5 for ; Mon, 15 Mar 2010 17:36:55 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mail.codecraft.se (Postfix) with ESMTP id 0C6FE975BF1; Mon, 15 Mar 2010 20:45:04 +0100 (CET) Received: from mail.codecraft.se ([127.0.0.1]) by localhost (archer.codecraft.se [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26117-06; Mon, 15 Mar 2010 20:45:02 +0100 (CET) Received: from [192.168.1.65] (c-f500e655.541-1-64736c10.cust.bredbandsbolaget.se [85.230.0.245]) by mail.codecraft.se (Postfix) with ESMTP id 97273975BE0; Mon, 15 Mar 2010 20:45:02 +0100 (CET) In-Reply-To: <11c2d5211003151218y4ce9218du20034785a8103c39@mail.gmail.com> References: <11c2d5211003151218y4ce9218du20034785a8103c39@mail.gmail.com> Mime-Version: 1.0 (Apple Message framework v753.1) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <3B3D9C6D-46DC-4025-9413-CA243CBF4512@codecraft.se> Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit From: Niklas Johansson Subject: Re: I, nead to capture the IP number from the PC how is running the script ... Date: Mon, 15 Mar 2010 20:41:35 +0100 To: John Dizaro X-Mailer: Apple Mail (2.753.1) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.11 tagged_above=-10 required=5 tests=BAYES_05=-1.11 X-Spam-Level: X-Archive-Number: 201003/104 X-Sequence-Number: 33811 On 15 mar 2010, at 20.18, John Dizaro wrote: > I, nead to capture the IP number from the PC how is running the script Check the documentation for System Information Functions: http://www.postgresql.org/docs/8.4/interactive/functions-info.html The function inet_client_addr() will return the address of the remote connection. Sincerely, Niklas Johansson