Get client's IP 
Author Message
 Get client's IP

I had asked the same question few months back but did not get any
response :-(

mallah.


Quote:
> Hi!

> i'm actually make and audit function for use with a trigger, in this
> function i want to store in a table the client's ip address, there is any
> postgresql's function to obtain it? like getpgusername o similar?

> thanks in adavance...

> Gabriel.

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.***.com/ ,
India's Leading B2B eMarketplace.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.***.com/



Wed, 22 Jun 2005 19:03:32 GMT
 Get client's IP

AFAIK there is no such function.  I think you could create one in C by
look at both the semantics of pggetusername and the code that captures
connection ips for purpose of writing to the log files.

Robert Treat

Quote:

> I had asked the same question few months back but did not get any
> response :-(

> mallah.


> > Hi!

> > i'm actually make and audit function for use with a trigger, in this
> > function i want to store in a table the client's ip address, there is any
> > postgresql's function to obtain it? like getpgusername o similar?

> > thanks in adavance...

> > Gabriel.

> --
> Rajesh Kumar Mallah,
> Project Manager (Development)
> Infocom Network Limited, New Delhi
> phone: +91(11)6152172 (221) (L) ,9811255597 (M)

> Visit http://www.trade-india.com ,
> India's Leading B2B eMarketplace.

> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?

> http://archives.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



Sat, 25 Jun 2005 04:27:39 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Getting IP address of client

2. Getting client IP possible???

3. Getting client ip address in NT environment

4. Getting client IP in sql server??

5. Getting Client IP

6. Getting client IP in sql server

7. Check Client's IP Connection to DB2 UDB

8. How do I capture a SQL client's ip address

9. Win '95 Clients and SQL 6.5 and TCP/IP Sockes

10. Oracle client won't start with IP but will with server name

11. Win '95 Clients and SQL 6.5 and TCP/IP Socked (sorry about formatting on previous)

12. How to get the client's IP?


 
Powered by phpBB® Forum Software