On 24-Apr-07, at 8:09 AM, Balazs Scheidler wrote: > Hi, > > Is there a way to query the record structure of a table through > libdbi? > I'm creating tables automatically from my program and I would like to > validate whether a given table matches my internal table > representation, > e.g. whether it has the appropriate fields. > > I've found a way to query the list of databases and the list of tables > in a database, but no way to query the list of fields found in a > table. > Is there something I missed? Is this feasible at all? (I know that > it is > possible to get the list of fields from MySQL and PostgreSQL, but I > don't know anything about the others) > > I might be interested in adding something like this, but I only know > MySQL and PgSQL, so I'd need some help for the rest of the drivers.
Ingres can do it (I contributed the libdbi-driver). Details are in the documentation. The effort to implement this across all drivers may not be worth it, however, since it's a fairly obscure need which probably can't work across all drivers anyway... IMHO. --Toby > > -- > Bazsi > > > ---------------------------------------------------------------------- > --- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Libdbi-drivers-devel mailing list > Libdbi-drivers-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Libdbi-drivers-devel mailing list Libdbi-drivers-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel
