AFAIK, I dont see any catalog's giving that information. --- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/
On Wed, Apr 18, 2012 at 7:20 PM, F. BROUARD / SQLpro < sql...@club-internet.fr> wrote: > Hi, > > is there anyway to have the value of Catalog version number in a query ? > I do not see it in pg_settings... > > > A + > > Le 18/04/2012 15:35, Raghavendra a écrit : > >> >> >> On Wed, Apr 18, 2012 at 6:22 PM, F. BROUARD / SQLpro >> <sql...@club-internet.fr >> <mailto:sqlpro@club-internet.**fr<sql...@club-internet.fr>>> >> wrote: >> >> Hi there, >> >> when creating a tablespace pointing to an existing directory, PG >> create a subderictory with this pattern : >> >> PG_???_!!!!!!!!! >> >> where ??? is the version (by instance 9.1) >> >> but I don't know what is !!!!!!!!!, actually 201105231 >> >> I can imagine that is a build version, but how can I obtain this >> number by a SQL Query ? >> >> >> Thats a system catalog version number. You can retrieve with >> pg_controldata >> >> Eg: >> >> -bash-4.1$ ./pg_controldata >> pg_control version number: 903 >> Catalog version number: 201105231 >> Database system identifier: 5719586032196955957 >> Database cluster state: in production >> >> >> --- >> Regards, >> Raghavendra >> EnterpriseDB Corporation >> Blog: http://raghavt.blogspot.com/ >> >> > > -- > Frédéric BROUARD - expert SGBDR et SQL - MVP SQL Server - 06 11 86 40 66 > Le site sur le langage SQL et les SGBDR : http://sqlpro.developpez.com > Enseignant Arts & Métiers PACA, ISEN Toulon et CESI/EXIA Aix en Provence > Audit, conseil, expertise, formation, modélisation, tuning, optimisation > *********************** http://www.sqlspot.com ************************* > >
