| From: | "Mario A(dot) Soto Cordones" <mario_soto(at)venezolanadeavaluos(dot)com> |
|---|---|
| To: | <mike(at)fuhr(dot)org> |
| Cc: | <mario_soto(at)venezolanadeavaluos(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Retrieve ip client from postgres |
| Date: | 2004-11-06 15:02:54 |
| Message-ID: | 47780.200.35.66.77.1099753374.squirrel@mail.venezolanadeavaluos.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2004-11-06 15:09:07 | Re: Gborg down? |
| Previous Message | Net Virtual Mailing Lists | 2004-11-06 14:34:01 | Can this be indexed? |