Just a brief question: When I need to know the running pg version i do a SELECT version();
and get this output: PostgreSQL 9.3.1, compiled by Visual C++ build 1600, 32-bit but I remember a 4 digit version numbering as 9.3.1-1 I can find this version convention used i.e. on http://www.ubuntuupdates.org/ppa/postgresql. Is there a way to query pg for the full version number? I googled around but found only many off topic results. I'm relatively new to pg admininistration so please excuse me if this is a dumb question. Thanks in advance