kinterbas db column type

Gandalf gandalf at geochemsource.com
Wed Nov 26 10:24:03 EST 2003


> i need to know the database column types returned by kinterbasdb.
> Implicit type conversion is i nice thing to have, but it hides the 
> real types in the database.
> So how could i get this information? 


If you use InterBase only, you can get that information from the 
metadatabase.
Try this:

RDB$RELATIONS - this stores table information
RDB$FIELDS - this is for the fields (here you have the RDB$FIELD_TYPE field)
RDB$RELATION_FIELDS - connects relations to fields

you can figure out the others. (Oh, it is for InterBase 6.0 but the 
others are similar or the same)

Cheers,

L 1.0







More information about the Python-list mailing list