Thread: Get client's IP

Get client's IP

From
"Ing. Gabriel Monsalvo"
Date:
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.

Re: Get client's IP

From
"Rajesh Kumar Mallah."
Date:
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.



Re: Get client's IP

From
Robert Treat
Date:
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