Skip site navigation (1) Skip section navigation (2)

Re: Looking for table in PostregSQL that contains Operating System and Processor information

From: Gregor Trefs <Gregor(dot)Trefs(at)delphit(dot)com>
To: Grzegorz Szpetkowski <gszpetkowski(at)gmail(dot)com>
Cc: "Lieu, Peter" <Peter_Lieu(at)bmc(dot)com>, "pgsql-novice(at)postgresql(dot)org"<pgsql-novice(at)postgresql(dot)org>
Subject: Re: Looking for table in PostregSQL that contains Operating System and Processor information
Date: 2011-05-05 12:44:07
Message-ID: 4DC29B97.2090903@delphit.com (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)bmc(dot)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


In response to

Responses

pgsql-novice by date

Next:From: Grzegorz SzpetkowskiDate: 2011-05-05 12:55:41
Subject: Re: Looking for table in PostregSQL that contains Operating System and Processor information
Previous:From: Grzegorz SzpetkowskiDate: 2011-05-05 12:14:02
Subject: Re: Looking for table in PostregSQL that contains Operating System and Processor information

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group