Pg version number format

From: Tiziano Valdemarin <tizianovaldemarin(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Pg version number format
Date: 2013-11-13 16:17:14
Message-ID: CAHzW5VF-BqbaoCj6zLc6k=PRKL=ZPP71E_9Cyi3XhzW1VY0jxg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2013-11-13 16:23:31 Re: Pg version number format
Previous Message Scott Ribe 2013-11-13 15:58:18 what checksum algo?