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:[EMAIL PROTECTED]
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/
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
