pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Benjamin Krajmalnik <kraj@illumen.com>
Cc: Adam Witney <awitney@sgul.ac.uk>
Cc: pgsql-admin@postgresql.org, "Abraham, Danny" <danny_abraham@bmc.com>
Subject: Re: How can I tell that the underlying OS is Windows?
Date: Thu, 12 Jul 2007 14:52:40 -0700
Message-ID: <4696A2A8.9080305@commandprompt.com> (raw)
In-Reply-To: <F4E6A2751A2823418A21D4A160B6898807A672@fletch.stackdump.local>
References: <F8B9B12641FB6B4FAC761BDEF9D63B040DC4A1BC@tlv-ex-01.adprod.bmc.com>
	<C2BC08AD.150EC%awitney@sgul.ac.uk>
	<F4E6A2751A2823418A21D4A160B6898807A671@fletch.stackdump.local>
	<46969F61.5040701@commandprompt.com>
	<F4E6A2751A2823418A21D4A160B6898807A672@fletch.stackdump.local>

Benjamin Krajmalnik wrote:
> My mistake.
> I was connecting to remote machines and must have accidentally issued
> the version on the same box :(

How about this :)

SELECT * FROM version() WHERE version ~* 'gcc.exe' OR version ~* 'msvc';

You probably want to replace msvc with whatever that would be on MSVC.

Joshua D. Drake



> 
> BSD is returning:
> 
> "PostgreSQL 8.1.5 on i386-portbld-freebsd6.1, compiled by GCC cc (GCC)
> 3.4.4 [FreeBSD] 20050518"
> 
> 
>> -----Original Message-----
>> From: Joshua D. Drake [mailto:jd@commandprompt.com] 
>> Sent: Thursday, July 12, 2007 3:39 PM
>> To: Benjamin Krajmalnik
>> Cc: Adam Witney; pgsql-admin@postgresql.org; Abraham, Danny
>> Subject: Re: [ADMIN] How can I tell that the underlying OS is Windows?
>>
>> Benjamin Krajmalnik wrote:
>>> My Windows box says: 
>>> "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
>>> 3.4.2 (mingw-special)" 
>>>
>>> My BSD box says:
>>> "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
>>> 3.4.2 (mingw-special)"
>>>
>>> Seems to be the same
>> Your bsd box appears to be connection to a postgresql on 
>> windows machine.
>>
>> Joshua D. Drake
>>
>>
>>> ---------------------------(end of 
>>> broadcast)---------------------------
>>> TIP 7: You can help support the PostgreSQL project by donating at
>>>
>>>                 http://www.postgresql.org/about/donate
>>>
>>
>> -- 
>>
>>        === The PostgreSQL Company: Command Prompt, Inc. ===
>> Sales/Support: +1.503.667.4564 || 24x7/Emergency: 
>> +1.800.492.2240 Providing the most comprehensive  PostgreSQL 
>> solutions since 1997
>>               http://www.commandprompt.com/
>>
>> Donate to the PostgreSQL Project: 
>> http://www.postgresql.org/about/donate
>> PostgreSQL Replication: http://www.commandprompt.com/products/
>>
>>
> 


-- 

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/




view thread (7+ messages)

Message-ID: <4696A2A8.9080305@commandprompt.com>
Permalink:  ../4696A2A8.9080305@commandprompt.com/
Also on:    postgresql.org/message-id/4696A2A8.9080305@commandprompt.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: jd@commandprompt.com, kraj@illumen.com, awitney@sgul.ac.uk, danny_abraham@bmc.com
  Subject: Re: How can I tell that the underlying OS is Windows?
  In-Reply-To: <4696A2A8.9080305@commandprompt.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox