Thread: Get client's IP
Hi!
i'm actually make and audit function for use with a trigger, in this function i want to store in a table the client's ip address, there is any postgresql's function to obtain it? like getpgusername o similar?
thanks in adavance...
Gabriel.
I had asked the same question few months back but did not get any response :-( mallah. On Tuesday 31 December 2002 01:31 am, Ing. Gabriel Monsalvo wrote: > Hi! > > i'm actually make and audit function for use with a trigger, in this > function i want to store in a table the client's ip address, there is any > postgresql's function to obtain it? like getpgusername o similar? > > thanks in adavance... > > > Gabriel. -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.
AFAIK there is no such function. I think you could create one in C by look at both the semantics of pggetusername and the code that captures connection ips for purpose of writing to the log files. Robert Treat On Sat, 2003-01-04 at 06:08, Rajesh Kumar Mallah. wrote: > > I had asked the same question few months back but did not get any > response :-( > > > mallah. > > On Tuesday 31 December 2002 01:31 am, Ing. Gabriel Monsalvo wrote: > > Hi! > > > > i'm actually make and audit function for use with a trigger, in this > > function i want to store in a table the client's ip address, there is any > > postgresql's function to obtain it? like getpgusername o similar? > > > > thanks in adavance... > > > > > > Gabriel. > > -- > Rajesh Kumar Mallah, > Project Manager (Development) > Infocom Network Limited, New Delhi > phone: +91(11)6152172 (221) (L) ,9811255597 (M) > > Visit http://www.trade-india.com , > India's Leading B2B eMarketplace. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org