Обсуждение: Retrieve ip client from postgres
Hi, How can i get the Client Host name/IP Address for the current connection(session). Is there any function or system table(view) which will these details. Thank
On Fri, Nov 05, 2004 at 04:21:52PM -0400, Mario A. Soto Cordones wrote: > How can i get the Client Host name/IP Address for the current > connection(session). Is there any function or system table(view) which > will these details. In 8.0 you'll be able to use inet_client_addr(). I don't think you could get this info in earlier versions, although I recall seeing an user-defined function that somebody had written. Use a search engine and see if anything comes up. -- Michael Fuhr http://www.fuhr.org/~mfuhr/
OK thank you > On Fri, Nov 05, 2004 at 04:21:52PM -0400, Mario A. Soto Cordones wrote: > >> How can i get the Client Host name/IP Address for the current >> connection(session). Is there any function or system table(view) which >> will these details. > > In 8.0 you'll be able to use inet_client_addr(). I don't think you > could get this info in earlier versions, although I recall seeing > an user-defined function that somebody had written. Use a search > engine and see if anything comes up. > > -- > Michael Fuhr > http://www.fuhr.org/~mfuhr/ > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings