Обсуждение: 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