Postgres Pro
Downloads
Home   >   mailing lists

- tablespace and directory - Mailing list pgsql-general

From F. BROUARD / SQLpro
Subject - tablespace and directory
Date
Msg-id 4F8EB915.9010304@club-internet.fr
Whole thread Raw
Responses Re: - tablespace and directory  (Raghavendra <raghavendra.rao@enterprisedb.com>)
Re: - tablespace and directory  (Chetan Suttraway <chetan.suttraway@enterprisedb.com>)
List pgsql-general
Tree view 
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 ?

Thanks a lot

--
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 *************************

pgsql-general by date:

Previous
From: David Larochelle
Date:
Subject: Detecting corrupt table
Next
From: Raghavendra
Date:
Subject: Re: - tablespace and directory