Re: How can I tell that the underlying OS is Windows?

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(at)commandprompt(dot)com]
>> Sent: Thursday, July 12, 2007 3:39 PM
>> To: Benjamin Krajmalnik
>> Cc: Adam Witney; pgsql-admin(at)postgresql(dot)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/