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