Hello,
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
fortypes 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.
Regards
Thomas