Re: Function to get hostname

From: David Mitchell <david(dot)mitchell(at)telogis(dot)com>
To: Seth Williams <swilliams(at)highstreetnetworks(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Function to get hostname
Date: 2004-07-15 03:57:33
Message-ID: 40F600AD.10909@telogis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Did you ever figure out how to do this? I'd be really keen to know.
Currently I'm looking at writing a plruby function that returns
Socket.gethostname

Seth Williams wrote:
> Is there any way within an sql query to get the local server's hostname?
> I am trying to build up a string of '
> <mailto:'user(at)hostname'>user(at)hostname <mailto:'user(at)hostname>' where the
> user is defined in a column and the latter is concatenated on.
>
>

--
David Mitchell
Software Engineer
Telogis

NOTICE:
This message (including any attachments) contains CONFIDENTIAL
INFORMATION intended for a specific individual and purpose, and
is protected by law. If you are not the intended recipient,
you should delete this message and are hereby notified that any
disclosure, copying, or distribution of this message, or the
taking of any action based on it, is strictly prohibited.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brian K Boonstra 2004-07-15 04:07:39 Aggregate functions with two or more arguments?
Previous Message Bruce Momjian 2004-07-15 03:36:10 Re: determining supported timezones