How to get a list of table names for a database via ODBC in Windows using mxODBC/python?

Dennis Lee Bieber wlfraed at ix.netcom.com
Sun Oct 6 18:42:01 EDT 2002


Chris Humphries fed this fish to the penguins on Sunday 06 October 2002 
11:28 am:

> pg_tables for postgresql.
> 
> something like this:
> 
> "select tablename from pg_tables where tablename !~ '^pg_'"
>

        Of course, MySQL decides to be strange... "show tables"; there doesn't 
seem to be a master index of tables in a database other than what MySQL 
finds in scanning the database directory.

        Haven't found what you'd use with M$ SQL Server...

--  
 > ============================================================== <
 >   wlfraed at ix.netcom.com  | Wulfraed  Dennis Lee Bieber  KD6MOG <
 >      wulfraed at dm.net     |       Bestiaria Support Staff       <
 > ============================================================== <
 >        Bestiaria Home Page: http://www.beastie.dm.net/         <
 >            Home Page: http://www.dm.net/~wulfraed/             <



More information about the Python-list mailing list