Re: Pg version number format

On 13 November 2013 17:17, Tiziano Valdemarin
<tizianovaldemarin(at)gmail(dot)com> wrote:
> 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.

The full version number is 9.3.1. The extra -1 you see is probably
added by the ubuntu package maintainers to refer to the version of the
package, not the version of the product.

If you ever see a 9.3.1-2, that just means Ubuntu repackaged the same
version of PG for some reason.

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.