Home > mailing lists

Pg version number format - Mailing list pgsql-general

From	Tiziano Valdemarin
Subject	Pg version number format
Date	November 13, 2013 19:18:01
Msg-id	CAHzW5VF-BqbaoCj6zLc6k=PRKL=ZPP71E_9Cyi3XhzW1VY0jxg@mail.gmail.com Whole thread Raw
Responses	Re: Pg version number format Re: Pg version number format
List	pgsql-general

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

From: Scott Ribe
Date: 13 November 2013, 18:58:32
Subject: what checksum algo?

From: David Johnston
Date: 13 November 2013, 19:23:40
Subject: Re: Pg version number format