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.""" -- Patriotism means to stand by the country. It does not mean to stand by the president. -- T. Roosevelt This message has been scanned for memes and dangerous content by MindScanner, and is believed to be unclean. _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
