Pg version number format

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

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general