Thread: How to get the IP address of the conneced user
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.
On Thu, 2003-02-20 at 16:39, Egyud Csaba wrote: > I'd like to get the IP address of the connected user from a plpgsql > function, but I don't know how. Connections to PostgreSQL don't need to be made over TCP/IP, so this property may not even exist. Cheers, Neil -- Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
Do you think so? It's sad. I start to find an other way, but if anybody knows something clever, please inform me. Best Regards, Csaba ----- Original Message ----- From: "Neil Conway" <neilc@samurai.com> To: "Egyud Csaba" <csegyud@freemail.hu> Cc: "pgsql-general" <pgsql-general@postgresql.org> Sent: Thursday, February 20, 2003 5:09 PM Subject: Re: [GENERAL] How to get the IP address of the conneced user > On Thu, 2003-02-20 at 16:39, Egyud Csaba wrote: > > I'd like to get the IP address of the connected user from a plpgsql > > function, but I don't know how. > > Connections to PostgreSQL don't need to be made over TCP/IP, so this > property may not even exist. > > Cheers, > > Neil > -- > Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC > > > > > > --- 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.