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

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 ad

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

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 connec

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

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 -- Sent v

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

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) -0303 Fone: (41) 9243-3240 Rua: Alferes Poli Curitiba - PR - Brasil inet_client_addr(): ine

[SQL] I, nead to capture the IP number from the PC how is running the script ...

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) -0303 Fone: (41) 9243-3240 Rua: Alferes Poli Curitiba - PR - Brasil