Re: ip of the user doing an insert

From: Randolf Richardson <rr(at)8x(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: ip of the user doing an insert
Date: 2003-11-29 00:27:37
Message-ID: Xns9441A56BE769Drr8xca@200.46.204.72
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Is there a function or other way to get the user's ip address the moment
> an insert is performed?
> Supposed that many people with the same "pg_username" are conected to
> the database so no username tracking is usefull.

If this isn't a feature now, hopefully it will be in the future, but I
assume it will have to return the address as a string since IPv4 and IPv6 are
formatted differently.

--
Randolf Richardson - rr(at)8x(dot)ca
Vancouver, British Columbia, Canada

Please do not eMail me directly when responding
to my postings in the newsgroups.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2003-11-29 00:34:02 Re: PostgreSQL, MySQL, etc., was Re: PostgreSQL is much faster than MySQL, only when...
Previous Message Joe Conway 2003-11-29 00:16:29 Re: aggregate generic ANYARRAY