| From: | "F(dot) BROUARD / SQLpro" <sqlpro(at)club-internet(dot)fr> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | - tablespace and directory |
| Date: | 2012-04-18 12:52:37 |
| Message-ID: | 4F8EB915.9010304@club-internet.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 *************************
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raghavendra | 2012-04-18 13:35:18 | Re: - tablespace and directory |
| Previous Message | Michael Paquier | 2012-04-18 11:36:27 | Re: Compile docs on ArchLinux |