How to get the IP address of the conneced user

Поиск
Список
Период
Сортировка
От Egyud Csaba
Тема How to get the IP address of the conneced user
Дата
Msg-id 002701c2d928$a9ce8b40$800a0a0a@xxx
обсуждение исходный текст
Ответы Re: How to get the IP address of the conneced user
Список pgsql-general
Hello,
I'd like to get the IP address of the connected user from a plpgsql function, but I don't know how.
The user connects to the database through the odbc facility.  (Server:RH7.1, Postgres 7.3.1, Client: Windows..., odbc).
Is there a function or a constant in Postgres (such as CURRENT_TIMESTAMP or similar) holding this value?
 
thanks,
Csaba
 
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.435 / Virus Database: 244 - Release Date: 2002.12.30.

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

Предыдущее
От: Justin Clift
Дата:
Сообщение: Re: Open Source Development Lab resources
Следующее
От: "Roberto de Amorim"
Дата:
Сообщение: Re: BLOB or BYTEA field