DB_common::tableInfo() extension
| From: | Luca Mariano | Date: | Thu, 14 Apr 2005 14:54:00 +0000 |
| Subject: | DB_common::tableInfo() extension | ||
| Groups: | php.pear.dev | ||
| Request: | Send a blank email to pear-dev+get-37240@lists.php.net to get a copy of this message | ||
Hi people,
while working on a personal ERD project that uses DB instrospect
functionality of PEAR::DB, I noticed that the DB::tableInfo() method only
returns a poor set of info for most of supported DBMS...
For example while dealing with oracle we can easily fetch foreign keys,
constraints & indexes infos; this is often useful and fully supported by the
backend.
If anyone thinks this can stuff can be useful to pear, please take a look at
the attached patches (at this moment I only added FK info, only for the OCI8
driver).
Bye,
Luca Mariano
Attachment: [text/x-patch] common.diff
Attachment: [text/x-patch] oci8.diff
Attachment: [text/x-patch] common.diff
Attachment: [text/x-patch] oci8.diff