metadata searching - Mailing list pgsql-jdbc

From Juriy Goloveshkin
Subject metadata searching
Date
Msg-id 002101c3e897$94def010$efc745d9@hjugonb
Whole thread Raw
Responses Re: metadata searching  (Oliver Jowett <oliver@opencloud.com>)
Re: metadata searching  (Mofeed Shahin <mofeed.shahin@dsto.defence.gov.au>)
Re: metadata searching  (Barry Lind <blind@xythos.com>)
List pgsql-jdbc
Hello.

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?



pgsql-jdbc by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Any known memory leaks in the driver ... ?
Next
From: Oliver Jowett
Date:
Subject: Re: metadata searching