From: Gerardo Herzig <gherzig@fmed.uba.ar>
To: John Dizaro <jedsoftware@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: I, nead to capture the IP number from the PC how is running the script ...
Date: Mon, 15 Mar 2010 17:40:52 -0300
Message-ID: <4B9E9B54.1040306@fmed.uba.ar> (raw)
In-Reply-To: <11c2d5211003151218y4ce9218du20034785a8103c39@mail.gmail.com>
References: <11c2d5211003151218y4ce9218du20034785a8103c39@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gherzig@fmed.uba.ar, jedsoftware@gmail.com
Subject: Re: I, nead to capture the IP number from the PC how is running the script ...
In-Reply-To: <4B9E9B54.1040306@fmed.uba.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox