Postgres Pro
Downloads
Home   >   mailing lists

Re: I, nead to capture the IP number from the PC how is running the script ... - Mailing list pgsql-sql

From Gerardo Herzig
Subject Re: I, nead to capture the IP number from the PC how is running the script ...
Date
Msg-id 4B9E9B54.1040306@fmed.uba.ar
Whole thread Raw
In response to I, nead to capture the IP number from the PC how is running the script ...  (John Dizaro <jedsoftware@gmail.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Ing. Marcos Ortiz Valmaseda"
Date:
Subject: Re: I, nead to capture the IP number from the PC how is running the script ...
Next
From: "Garrett Murphy"
Date:
Subject: Re: list of all months