Thread: Function to get client IP address

Function to get client IP address

From

"Donald Fraser"

Date:

16 July 2004, 17:38:37

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);
}