Re: 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.