[ADMIN] Function to get client IP address

[Donald Fraser]

Hi, I've been looking through the mail archives in the hope of finding a function to get the client IP address according to the backend. Found lots of requests but no actual answers or examples. I've trawled through the backend code and as a result created a function to do the job. I thought I would post it here (may be it should go into hackers) so that others can find and use it as they wish.   regards Donald Fraser.     Place the following into an appropriate file and follow the c compiling rules as with contrib examples.   #include "postgres.h" #include "miscadmin.h" #include "libpq/libpq.h" extern Datum get_ip_address(PG_FUNCTION_ARGS); PG_FUNCTION_INFO_V1(get_ip_address);   extern Datum get_ip_address(PG_FUNCTION_ARGS) {  char  remote_addr_s[NI_MAXHOST];  char  remote_port[NI_MAXSERV];  text       *ptext;    getnameinfo_all(&(MyProcPort->raddr.addr), MyProcPort->raddr.salen,      remote_addr_s, sizeof(remote_addr_s),      remote_port, sizeof(remote_port),      NI_NUMERICHOST | NI_NUMERICSERV);     ptext = DatumGetTextP(DirectFunctionCall1(textin, CStringGetDatum(&remote_addr_s[0])));     if (ptext == NULL)      PG_RETURN_NULL();     PG_RETURN_TEXT_P(ptext); }