Re: Retrieve ip client from postgres

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: Retrieve ip client from postgres
Дата
Msg-id 20041105234444.GA26745@winnie.fuhr.org
обсуждение исходный текст
Ответ на Retrieve ip client from postgres  ("Mario A. Soto Cordones" <mario_soto@venezolanadeavaluos.com>)
Ответы Re: Retrieve ip client from postgres  ("Mario A. Soto Cordones" <mario_soto@venezolanadeavaluos.com>)
Список pgsql-general
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/

В списке pgsql-general по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Converting number to words
Следующее
От: "Goutam Paruchuri"
Дата:
Сообщение: Re: Copy command and import - MS SQL Server to Postgres