On Jan 10, 2006, at 6:38 PM, Michael Bayer wrote:
> well if you are referring to the "information schema" that postgres
> uses, only postgres has that specific schema represented within it
> (and its also quite complicated). Mysql seems to support a slightly
> different version of it and also one that doenst seem to work
> completely. other databases that I know of have no notion of that
> particular style of information schema (oracle for example has the
> data dictionary which is completely different).
sorry, yes; i primarily use postgres and my
impressions are probably skewed from that.
nevertheless, my impression had been (and
seems to be confirmed based on googling),
that the information_schema is part of sql92,
and hence for what it's worth "standard".
Yes, that's correct. However, MySQL's reputation for poor standards conformance is nothing if not well-deserved.
-Jonathan
