Re: Is there anyway to retrieve server name and/or ip from query

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Chris Hoover <revoohc(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Is there anyway to retrieve server name and/or ip from query
Date: 2005-07-29 14:00:29
Message-ID: 200507291400.j6TE0Tl24281@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Chris Hoover wrote:
> Subject pretty much says it all. Is there a way in a sql query to
> have it return the server name and/or the server ip address of the
> PostgreSQL server?

8.0 has such informix via functions:

test=> \df *server*
List of functions
Schema | Name | Result data type | Argument data types
------------+------------------+------------------+---------------------
pg_catalog | inet_server_addr | inet |
pg_catalog | inet_server_port | integer |
(2 rows)

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Fuhr 2005-07-29 14:15:31 Re: Is there anyway to retrieve server name and/or ip from query
Previous Message Tom Lane 2005-07-29 13:52:19 Re: start postgresql8 with -o "-i" option