Re: Get postgresql server ip address

From: Chris Browne <cbbrowne(at)acm(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Get postgresql server ip address
Date: 2011-02-08 15:30:42
Message-ID: 87vd0uzgpp.fsf@cbbrowne.afilias-int.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

geramel(dot)h(at)gmail(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Shawn Tayler 2011-02-08 18:09:50 Re: Cumulative result with increment
Previous Message Dmitriy Igrishin 2011-02-08 14:56:57 Re: Get postgresql server ip address