A basic version of the SQL information schema is now available in newly
initdb'ed database installations.  There's still a bunch of work to do to
create all the views that the spec defines.

-- 
Peter Eisentraut   peter_e@gmx.net


Sat, 14 Dec 2002 01:32:09 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Information schema now available
Peter Eisentraut kirjutas L, 14.12.2002 kell 05:32:
> A basic version of the SQL information schema is now available in newly
> initdb'ed database installations.

Could you also post it somewhere as a plain SQL script for 7.3 ?

IMHO this should become the default way for \d, ODBC, JDBC, and other
similar interfaces for getting at this information and making it
available for 7.3 would give the implementors of those a head start.

> >  There's still a bunch of work to do to
> create all the views that the spec defines.

I'm sure you will get more help if it is available as add-on for 7.3.

-- 
Hannu Krosing <hannu@tm.ee>

15 Dec 2002 00:10:16 +0500
Hannu Krosing <hannu@tm.ee>
Re: Information schema now available
Hannu Krosing writes:

> Could you also post it somewhere as a plain SQL script for 7.3 ?

It depends on SQL features not present in 7.3.  But you can download it
from the CVS web interface and make the adjustments yourself if you want
to use it.

-- 
Peter Eisentraut   peter_e@gmx.net


Sun, 15 Dec 2002 17:22:31 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: Information schema now available