Re: Views, views, views! (long)

Peter,

> I can think of a couple of ways offhand about how the information schema
> could be extended without breaking the SQL standard.  You could just
> add columns where needed.  Or you could add tables that are joined to
> the standard tables and contain the extra information.  Or you could
> create a "information_schema_2" that contains a copy of the original
> information schema with the extra information added somewhere, so users
> can easily switch back and forth.
>
> If you look closer, there isn't really all that much that cannot be
> gotten from the information schema.  Figuring out exactly what that is
> might be instructive before deciding how to go forward.

This makes sense; I do wish that someone had mentioned it when I originally 
raised the subject of new system views.  It would have saved us some work.

--Josh

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco