Обсуждение: Pg version number format
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
Tiziano Valdemarin 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. > > I'm relatively new to pg admininistration so please excuse me if this is a > dumb question. > > Thanks in advance That id is assigned at the package level, not within PostgreSQL. You can probably query APT to get the information you need. Depending on why you need the version the 9.3.1 might be sufficient as it does fully identify the deployed version of PostgreSQL regardless of distro. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Pg-version-number-format-tp5778184p5778185.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On 13 November 2013 17:17, Tiziano Valdemarin <tizianovaldemarin@gmail.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.