In such way you can determine OS and bit's of hardware in which
PostgreSQL were compilied, not current server.
For example I have Debian 5 and select version(); returns:
PostgreSQL 8.3.14 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real
(Debian 4.3.2-1.1) 4.3.2
Regards,
Grzegorz Szpetkowski
2011/5/5 Gregor Trefs <Gregor.Trefs@delphit.com>:
> Isn't the version() function an easier way ?
> If you execute the command "SELECT version();" you will get something like
> "PostgreSQL 8.4.8 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real
> (Ubuntu/Linaro 4.4.4-14ubuntu5) 4.4.5, 64-bit".
> Well, you don't get any information about your processor speed, but you can
> determine the OS and the bits of your processor.
> Maybe you can write a pspgsql function using some of the string manipulation
> functions and returning a convient record type, which you can use in your
> FROM clause.
>
> Regards,
> Gregor Trefs
>
> Am 05.05.2011 14:14, schrieb Grzegorz Szpetkowski:
>>
>> AFAIK PostgreSQL does not include such table, but with a little effort
>> you create it by yourself using server's system tools. For example in
>> Debian:
>>
>> 1. OS
>> lsb_release -ds
>> Debian GNU/Linux 5.0.8 (lenny)
>>
>> 2. Platform (i386/i486/i586/i686 means "32 bit" and x86_64 is "64 bit")
>> uname -m
>> i686
>>
>> 3. CPU
>> cat /proc/cpuinfo | grep "model name" | cut -d ':' -f 2 | tr -s ' '
>> Intel(R) Core(TM) xx CPU M xxx @ x.xxGHz
>>
>> Regards,
>> Grzegorz Szpetkowski
>>
>> 2011/5/5 Lieu, Peter<Peter_Lieu@bmc.com>:
>>>
>>> Hi,
>>>
>>>
>>>
>>> I am new to PostreqSQL and I would like to know if there is a table in
>>> PostregSQL database that contains the Operating System, Platform, and
>>> Processor information which the PostregSQL database server is running on.
>>>
>>>
>>>
>>> Thank you very much for taking my question.
>>>
>>>
>>>
>>> Regards,
>>>
>>> Peter Lieu
>
>
