Re: Retrieve ip client from postgres - Mailing list pgsql-general

From Mario A. Soto Cordones
Subject Re: Retrieve ip client from postgres
Date
Msg-id 47780.200.35.66.77.1099753374.squirrel@mail.venezolanadeavaluos.com
Whole thread Raw
In response to Re: Retrieve ip client from postgres  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
OK
thank you

> On Fri, Nov 05, 2004 at 04:21:52PM -0400, Mario A. Soto Cordones wrote:
>
>> How can i get the Client Host name/IP Address for the current
>> connection(session). Is there any function or system table(view) which
>> will these details.
>
> In 8.0 you'll be able to use inet_client_addr().  I don't think you
> could get this info in earlier versions, although I recall seeing
> an user-defined function that somebody had written.  Use a search
> engine and see if anything comes up.
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings




pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Gborg down?
Next
From: Alvaro Herrera Munoz
Date:
Subject: Re: Gborg down?