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>

-----Original Message-----
From: Hannu Krosing [mailto:hannu@tm.ee]
Sent: 14 December 2002 19:10
To: Peter Eisentraut
Cc: PostgreSQL Development
Subject: Re: [HACKERS] 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.

Yes. I agree. pgAdmin III is at a stage in development now where I could
quite easily convert. In a couple of months it'll be a great deal more
work.

Regards, Dave.

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