Thread: Information schema now available
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
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