when defining a comment on a type like this:
create type footype as (id integer);
comment on type footype is 'foobar';
The driver will not return the comment in the remarks column when calling DatabaseMetaData.getTables()
The reason for this is, that AbstractJdbc2DatabaseMetaData joins pg_class against pg_description which is not correct for types as far as I can tell.
For types pg_description must be joined against pg_type (using pg_type.oid = pg_description.objid)
Not sure what the best method to integrate this into the statement used by getTables() would be though.
pgsql-jdbc by date
|Next:||From: Francisco Javier Morosini Eguren||Date: 2012-03-07 02:00:54|
|Previous:||From: Dave Cramer||Date: 2012-03-06 14:58:02|
|Subject: Re: JDBC4 Postgresql Driver, Version 9.1-901 - Is it stable or