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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
