Thread: Get postgresql server ip address
Hello, Is it possible to get postgresql server ip address using sql command? TIA, Geramel ----------------------------------------------------------------- "Share your knowledge. It's a way to achieve immortality" - Dalai Lama
2011/2/8 Gera Mel Handumon <geramel.h@gmail.com>
Hello,
Is it possible to get postgresql server ip address using sql command?
Oh yes, use inet_server_addr() function. Please note, that NULL is returned
if connection established via socket.
if connection established via socket.
TIA,
Geramel
-----------------------------------------------------------------
"Share your knowledge. It's a way to achieve immortality" - Dalai Lama
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
--
// Dmitriy.
geramel.h@gmail.com (Gera Mel Handumon) writes: > Is it possible to get postgresql server ip address using sql command? You can get the IP address tied to a specific connection... See the function inet_server_port(). Note, however, that the server may have a multiplicity of IP addresses, so this may only be a partial answer. -- output = ("cbbrowne" "@" "gmail.com") "A lot of people come to this newsgroup and do nothing but complain about Lisp. I think maybe they are such heavy complainers that they think they read comp.lain.lisp." -- Erik Naggum