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