pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedI, nead to capture the IP number from the PC how is running the script ...
5+ messages / 5 participants
[nested] [flat]
* I, nead to capture the IP number from the PC how is running the script ...
@ 2010-03-15 19:18 John Dizaro <jedsoftware@gmail.com>
0 siblings, 4 replies; 5+ messages in thread
From: John Dizaro @ 2010-03-15 19:18 UTC (permalink / raw)
To: pgsql-sql
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?
--
John Evan Dizaro -
Fone: (41) 3333-0303
Fone: (41) 9243-3240
Rua: Alferes Poli Curitiba - PR - Brasil
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: I, nead to capture the IP number from the PC how is running the script ...
@ 2010-03-15 19:41 Niklas Johansson <niklas@codecraft.se>
parent: John Dizaro <jedsoftware@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: Niklas Johansson @ 2010-03-15 19:41 UTC (permalink / raw)
To: John Dizaro <jedsoftware@gmail.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: I, nead to capture the IP number from the PC how is running the script ...
@ 2010-03-15 20:19 Ing. Marcos Ortiz Valmaseda <mlortiz@uci.cu>
parent: John Dizaro <jedsoftware@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: Ing. Marcos Ortiz Valmaseda @ 2010-03-15 20:19 UTC (permalink / raw)
To: John Dizaro <jedsoftware@gmail.com>; +Cc: pgsql-sql
John Dizaro escribió:
> 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?
>
>
> --
> John Evan Dizaro -
> Fone: (41) 3333-0303
> Fone: (41) 9243-3240
> Rua: Alferes Poli Curitiba - PR - Brasil
inet_client_addr(): inet address of the client
inet_client_port(): client''s port number for this connection
Regards
--
--------------------------------------------------------
-- Ing. Marcos Luís Ortíz Valmaseda --
-- Twitter: http://twitter.com/@marcosluis2186 --
-- FreeBSD Fan/User --
-- http://www.freebsd.org/es --
-- Linux User # 418229 --
-- Database Architect/Administrator --
-- PostgreSQL RDBMS --
-- http://www.postgresql.org --
-- http://planetpostgresql.org --
-- http://www.postgresql-es.org --
--------------------------------------------------------
-- Data WareHouse -- Business Intelligence Apprentice --
-- http://www.tdwi.org --
--------------------------------------------------------
-- Ruby on Rails Fan/Developer --
-- http://rubyonrails.org --
--------------------------------------------------------
Comunidad Técnica Cubana de PostgreSQL
http://postgresql.uci.cu
http://personas.grm.uci.cu/+marcos
Centro de Tecnologías de Gestión de Datos (DATEC)
Contacto:
Correo: centalad@uci.cu
Telf: +53 07-837-3737
+53 07-837-3714
Universidad de las Ciencias Informáticas
http://www.uci.cu
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: I, nead to capture the IP number from the PC how is running the script ...
@ 2010-03-15 20:40 Gerardo Herzig <gherzig@fmed.uba.ar>
parent: John Dizaro <jedsoftware@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: Gerardo Herzig @ 2010-03-15 20:40 UTC (permalink / raw)
To: John Dizaro <jedsoftware@gmail.com>; +Cc: 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: I, nead to capture the IP number from the PC how is running the script ...
@ 2010-03-16 06:28 silly sad <sad@bankir.ru>
parent: John Dizaro <jedsoftware@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: silly sad @ 2010-03-16 06:28 UTC (permalink / raw)
To: John Dizaro <jedsoftware@gmail.com>; +Cc: pgsql-sql
On 03/15/10 22:18, John Dizaro wrote:
> I, nead to capture the IP number from the PC how is running the script
first of all you must tell us how your client is connected to your database?
there are a lot of different variants, and the most common of them is
not PG related at all while the connection is made via http.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2010-03-16 06:28 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-15 19:18 I, nead to capture the IP number from the PC how is running the script ... John Dizaro <jedsoftware@gmail.com>
2010-03-15 19:41 ` Niklas Johansson <niklas@codecraft.se>
2010-03-15 20:19 ` Re: I, nead to capture the IP number from the PC how is running the script ... Ing. Marcos Ortiz Valmaseda <mlortiz@uci.cu>
2010-03-15 20:40 ` Re: I, nead to capture the IP number from the PC how is running the script ... Gerardo Herzig <gherzig@fmed.uba.ar>
2010-03-16 06:28 ` silly sad <sad@bankir.ru>
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