|
From: Dru <an...@tr...> - 2004-03-07 09:00:55
|
just been going over libdbi and it looks very nice but i want to make some big feature requests. I'm sorry for just out right asking this, I'm being a bit greedy i know. I can help and do all the code for postgresql but i not very familure with mysql and how to do it in that or the other databases. And I dont even know if you would want such features to be supported. I'd like to be able to know more details and attributes of fields. - default value of a field, be it a function or a value. nice to know if it is a function or a value. - if its indexed or not. - if its a primary key. - if it is a char, what is string limit for storing in database. - if it has any constraints/forign relationships to another table and field. - if there is any comments made on the field. This stuff is all retrievable from postgresql, though it varies from postgresql verisons. if the database doesnt support it we could ask for it to be supported. General db stuff. - when you do an insert, get the id or oid of the record just inserted. mysql and postgresql have a function in standard api for this. - list all views in a database |