How to get the IP address of the conneced user

From: Egyud Csaba <csegyud(at)freemail(dot)hu>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: How to get the IP address of the conneced user
Date: 2003-02-20 21:39:30
Message-ID: 002701c2d928$a9ce8b40$800a0a0a@xxx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-02-20 22:20:28 Re: using PGPASSWORD environment variable
Previous Message Eric B.Ridge 2003-02-20 21:35:32 Re: Fwd: REWRITE_INVOKE_MAX and "query may contain cycles"