Postgres Pro
Downloads
Home   >   mailing lists

How to get the IP address of the conneced user - Mailing list pgsql-general

From Egyud Csaba
Subject How to get the IP address of the conneced user
Date
Msg-id 002701c2d928$a9ce8b40$800a0a0a@xxx
Whole thread Raw
Responses Re: How to get the IP address of the conneced user  (Neil Conway <neilc@samurai.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Justin Clift
Date:
Subject: Re: Open Source Development Lab resources
Next
From: "Roberto de Amorim"
Date:
Subject: Re: BLOB or BYTEA field