Re: metadata searching

> > I have a problem with jdbc driver.
> >
> > There is one java program. It can create tables by name if it doesn`t
exist.
> >
> > If tabe name has upper letters like 'Base', then create statement looks
like
> > 'create Base (...' and postgresql create table in lowercase.
> > Then if I want to know is there the table 'Base' I use
> >
> > DatabaseMetaData.getTables(null, "%", name, types) and...
(name="Bases")...
> > no tables found.
> >
> > may be when jdbc driver searches information by name, it is reasonable
to
> > lowercase it or use ilike in statements?
> >
> > I think if postgresql is sql-insensetive (select from Base == select
from
> > base), jdbc have to be insensetive too.
> > What do you think?
>
> What happens when you have two tables that differ only in case? Seems
> like the current behaviour is correct to me.

Ok. Are You want to say that the different behavior in sql engine and jdbc
code is normal?
why I can build sql statement like 'select from Base' and 'select from base'
while I have only one table 'base',
but getTables(..., "Base", ...) and getTables(..., "base", ...) gives me a
diffenent result.
Where is the logic?
What about psql?
\d Base
\d base
gives me info about the table 'base'. but not jdbc getTables(). pretty nice.

I think the logic of things like getTables have to be the same as the sql
engine.