I am trying to retrieve information about the structure of the database 
using the DatabaseMetadata class.  I am using version 7.1.3 and the latest 
JDBC Drivers I can find.  I got similar results with the versions supplied 
with Mandrake 8.0 (7.0.3 and associated drivers)

The problems are:

1. No Index information from the getIndexInfo method
2. Indexes included as tables in getTables
3. Only one column in the entire database is returned in getColumns
4. The catalog name is not returned in getTables
5. Comment columns contain 'No Comment' instead of null

I have tried many variations in the parameters, but would prefer 
catalogName = catalog, schema = null, and tableName = table (where 
appropriate).

None of these problems have occurred on Sun's JdbcOdbc Bridge, Oracle's or 
MySQL's drivers, so I am fairly confident that my code works.  Is there any 
chance of getting these problems fixed?  Where are the sources, as I am 
willing to take a look at them to try at least identify the problems in 
more detail, even if I don't know Posgres well enough to actually fix them.

Thanks,

Tom


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to