Re: I, nead to capture the IP number from the PC how is running the script ...

From: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>
To: John Dizaro <jedsoftware(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: I, nead to capture the IP number from the PC how is running the script ...
Date: 2010-03-15 20:40:52
Message-ID: 4B9E9B54.1040306@fmed.uba.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Garrett Murphy 2010-03-15 21:16:31 Re: list of all months
Previous Message Ing. Marcos Ortiz Valmaseda 2010-03-15 20:19:52 Re: I, nead to capture the IP number from the PC how is running the script ...