Re: Querying the hostname of the server

--- On Fri, 30/4/10, Ross J. Reedstrom <reedstrm(at)rice(dot)edu> wrote:

> > Hi,
> >
> > I have a number of PostgreSQL servers which I often
> access through ssh
> > tunnel with Pgadmin3. I would like to double check
> which one I have landed
> > on (if the tunnel is really configured the way I
> want). Is there a way to
> > query the hostname from the catalogs?
>
> Hmm, that's a bit tricky, since I assume you're using a
> local db
> connection inside the tunnel, so inet_server_addr()
> probably returns
> null. If you're talking unix/linux machines, then
> /etc/hostname _should_
> have the current hostname in it, so:
>
> create temp table foo (t text);
> copy foo from '/etc/hostname';
> select * from foo;
> drop table foo;
>
> Should work.
>

Or you could do something like:

CREATE OR REPLACE FUNCTION hostname()
RETURNS text AS
$BODY$
$host = `hostname`;
return $host;
$BODY$
LANGUAGE 'plperlu';