Re: Win32 version question

On Wed, 2004-06-30 at 11:16, Merlin Moncure wrote:
> > In phpPgAdmin, I need to know if the backend supports tablespaces or
> > not. What is the most reliable way of detecting that the backend is
> the
> > win32 native version and hence does not support tablespaces? Version
> > string info?
> >
> > Or alternatively, what is the most direct way of detecting its
> presence
> > or absence, regardless of backend OS?
>
> Check the uptime...if it's greater than 7 days, it's not win32 :).
>
> Seriously, you can check the version() string. If it's got mingw init,
> it's win32 native.
>

Does the win32 build have a pg_tablespace table? are there any rows in
it?

Was thinking the combination of the two queries would be able to
determine table space support in some fashion:

select * from pg_class where relnamespace = (select oid from
pg_namespace where nspname = 'pg_catalog') and relname =
'pg_tablespace';

select count(*) from pg_tablespace ;

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL