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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend