On May 18, 2007, at 12:19 PM, Andy Dustman wrote: > On 5/15/07, Michael Bayer <[EMAIL PROTECTED]> wrote: > >> the "standard" for database metadata are the information_schema >> tables/views, they are part of ANSI 2003. Currently, there is >> support for information_schema in postgres, mysql, SQL Server 7, and >> possibly Oracle. At least for the PG/mysql implementations, they are >> not compatible with each other and in the case of MySQL does not even >> provide complete information as compared its built-in commands. also >> information_schema is implemented as views within PG and have some >> performance issues. > > MySQL-5.0 has information_schema, too. > > http://dev.mysql.com/doc/refman/5.0/en/information-schema.html > > """The implementation for the INFORMATION_SCHEMA table structures in > MySQL follows the ANSI/ISO SQL:2003 standard Part 11 Schemata. Our > intent is approximate compliance with SQL:2003 core feature F021 Basic > information schema."""
the key phrase being "approximate compliance". computers love approximation. _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
