Thread: Function to get hostname
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.
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.