[DB-SIG] Dumping Table Schema

Jonan Santiago jonan-lists-python-db@callisia.com
Fri, 1 Dec 2000 19:10:15 -0500


Thanks both for your tips. Just what I needed. Now I dont know
why "select * from table where 1=0" works but it works!

-Jonan

Eugene V . Dvurechenski (jno@glasnet.ru) wrote:
> i believe, the only _portable_ way is to
> 
> 	1) cursor.execute( "select * from table where 1=0" )
> 	2) use cursor.description
> 
> anything else is tightly bound to the specific DBMS (all those
> SYS.ALL_* views in Oracle, for instance)
> 
> -jno