By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,178 Members | 971 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,178 IT Pros & Developers. It's quick & easy.

Retrieve ip client from postgres

P: n/a
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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 23 '05 #2

P: n/a
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



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.