Thread: Current Computer Name

Hi,
I would like to know how could
I do to get the host name from postgres.

Something like "CURRENT_HOSTNAME".

Thanx,


MAGO



--
NEU FÜR ALLE - GMX MediaCenter - für Fotos, Musik, Dateien...
Fotoalbum, File Sharing, MMS, Multimedia-Gruß, GMX FotoService

Jetzt kostenlos anmelden unter http://www.gmx.net

+++ GMX - die erste Adresse für Mail, Message, More! +++

On Thu, 2003-10-02 at 22:47, Marvin wrote:
> Because I would like to store in my table the name of the computer
> where the user saves the information.
>
> Whe have already into a MSSQL table the following definition:
>
> Field name      Type                Default
> IngUsername    nvarchar(50)   (suser_sname())
> IngDate             datetime          (getdate())
> IngPCName     nvarchar(50)   (host_name())
>
> So, I need to  emulate this in order to make
> the migration transparent to the application.
>
>
> Thank you for any suggestions.
>
>

You could write a function in C or PL/Perl...

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Set your affection on things above, not on things on
      the earth."          Colossians 3:2