| From: | "Juriy Goloveshkin" <j(at)gu(dot)ru> |
|---|---|
| To: | <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | metadata searching |
| Date: | 2004-02-01 07:47:02 |
| Message-ID: | 002101c3e897$94def010$efc745d9@hjugonb |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Pierre Matsumoto | 2004-02-01 12:07:36 | Re: FW: [webmaster] jdbc site: documentation links broken |
| Previous Message | Dave Cramer | 2004-02-01 05:15:48 | Re: FW: [webmaster] jdbc site: documentation links broken |