Retrieve ip client from postgres

[Mario A. Soto Cordones]

Hi,
How can i get the Client Host name/IP Address for the current
connection(sess ion). Is there any function or system table(view) which
will these details.

Thank





---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Michael Fuhr]

Re: Retrieve ip client from postgres

On Fri, Nov 05, 2004 at 04:21:52PM -0400, Mario A. Soto Cordones wrote:
[color=blue]
> How can i get the Client Host name/IP Address for the current
> connection(sess ion). Is there any function or system table(view) which
> will these details.[/color]

In 8.0 you'll be able to use inet_client_add r(). 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

[Mario A. Soto Cordones]

Re: Retrieve ip client from postgres

OK
thank you
[color=blue]
> On Fri, Nov 05, 2004 at 04:21:52PM -0400, Mario A. Soto Cordones wrote:
>[color=green]
>> How can i get the Client Host name/IP Address for the current
>> connection(sess ion). Is there any function or system table(view) which
>> will these details.[/color]
>
> In 8.0 you'll be able to use inet_client_add r(). 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[/color]




---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match