On Thu, Apr 05, 2007 at 07:57:41AM -0500, J. ORIOL wrote: > Hello, > > I was in the archives, looking for some concrete info about inet_client_addr() use, but only a C function found. > > I have some clients to my app. (PG 8.2 in XP LAN). I want to generate auto-logs with trigger function for every table and for every event, but I cannot include clint ip address yet. > > When the triggers starts and execute SELECT inet_client_addr(), will retrieve client's ip ?? or just 127.0.0.1 It should return the clients IP. (If you're using say a web-ap, that will be 127.0.0.1, since it can't know where the browser is. But if the client does a direct connection to the database, it should return it) //Magnus
