| 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: | Whole Thread | Raw Message | 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
| 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 |