Hi,
I think the new table_info, column_info etc methods for DBI are
really useful, but I was wondering whether there are any plans for some
less verbose/more simplistic API's for retrieving 'data dictionary' type
information, eg I think it would be useful to have something like:
my @columnNames = $dbh->columnsNamesForTable($schema, $table);
That would give me the column names for a given table,
or something like:
if ($dbh->columnIsNullable($schema, $table, $column){ ...
Now of course, I can probably write wrappers around the existing methods
that exist, but it would be great to get support at the DBI level for
these types of queries. Currently I do the bad (= non-portable) thing of
looking directly in the Oracle database dictionary for these types of
information.
By the way, thanks for the new DBI version!
Cheers,
Gavin
___________________________________________________________
Gavin Sherlock
Dept. of Genetics
Center for Clinical Sciences Research
269 Campus Drive,
Room 2255b,
Stanford,
CA 94305-5166
Tel: 650 498 6012
Fax: 650 723 7016
