On Wed, Jan 11, 2006 at 02:26:25PM +0530, Krishnendra Nandi wrote: > Could you please tell me how do i record information as to which ip > address the connection was when doing an update/insert in postgres.. > I need a trigger which would capture this information
In 8.0 and later you could use inet_client_addr(). See "System Information Functions" in the "Functions and Operators" chapter of the documentation for other such functions. If you just need the IP address stored somewhere, but not necessarily in a table, then you could tweak the server's logging options. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
