Re: Get postgresql server ip address

From: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
To: Gera Mel Handumon <geramel(dot)h(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Get postgresql server ip address
Date: 2011-02-08 14:56:57
Message-ID: AANLkTinwM1E5ULw=RA6Owz8PZfeDvUDEBDZKoP0NMF4B@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

2011/2/8 Gera Mel Handumon <geramel(dot)h(at)gmail(dot)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.

>
> TIA,
>
> Geramel
>
>
> -----------------------------------------------------------------
> "Share your knowledge. It's a way to achieve immortality" - Dalai Lama
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>

--
// Dmitriy.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Browne 2011-02-08 15:30:42 Re: Get postgresql server ip address
Previous Message Gera Mel Handumon 2011-02-08 10:28:38 Get postgresql server ip address