Thread: Function to get hostname

Function to get hostname

From
"Seth Williams"
Date:
Is there any way within an sql query to get the local server's hostname? I am trying to build up a string of 'user@hostname' where the user is defined in a column and the latter is concatenated on.
 
 

Re: Function to get hostname

From
David Mitchell
Date:
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@hostname'>user@hostname <mailto:'user@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.