Another option might be to look in the select pg_show_all_settings() for the ident_file. If the ident file is a DOS path (aka c:\somewhere\some dir\some file), you know you're on a Windows-based system. If it's a UNIX path, select version() will tell you specifically. -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Julio Leyva Sent: Thursday, October 08, 2009 4:14 PM To: louis.lam@xxxxxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: How to tell what OS PostgreSQL is installed on. as postgres user psql -c "select version()"; ________________________________ From: louis.lam@xxxxxxxxxxxx Date: Thu, 8 Oct 2009 16:58:33 -0400 Subject: How to tell what OS PostgreSQL is installed on. To: pgsql-admin@xxxxxxxxxxxxxx Hi, I have a need to find out what OS PostgreSQL is running under. I need to be able to query the database or send a command and figure it out. I also do not have super user permission to do this. All I want to know is if the PostgreSQL I am connected to is running from Windows or Non Windows. I could do "Show data_directory" and parse the result, but this require superuser permission. I tried select version() also. Under Windows OS, I got this: version --------------------------------------------------- PostgreSQL 8.3.6, compiled by Visual C++ build 1400 Does anyone know if Visual C++ is use to only compile PostgreSQL for Windows? Or can other compiler be use? If Visual C++ is always use for Windows and Windows only then this is very good information I can use. I know on RedHat, I got this. version ---------------------------------------------------------------------------- -------------------------- PostgreSQL 8.3.7 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-10) And on Solaris I got this. ----------------- PostgreSQL 8.1.11 on sparc-sun-solaris2.10, compiled by /ws/on10-tools/SUNWspro/SOS8/bin/cc -Xa (1 row) Thank you all in advance for your help. Louis Lam -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin