On 13 November 2013 17:17, Tiziano Valdemarin <tizianovaldemarin@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
