[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