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