This is because PostgreSQL allows the creation of case-sensitive table
If you run: CREATE TABLE MY_TABLE ...;
then the created table name is my_table.
But if you run: CREATE TABLE "MY_TABLE" ...;
then the created table name is MY_TABLE.
So in order for PG to differentiate between my_table and MY_TABLE, the
getTables() function has to be case-sensitive.
On Thu, 2006-07-20 at 18:21 +0200, Marc Herbert wrote:
> If I create table MY_TABLE (unquoted uppercase), then my_table
> (lowercase) is actually created. This is clearly documented, so fine.
> But now if I use .getTables(null, null, "MY_TABLE", null) to ask
> whether this table actually exists, the answer is "no" (empty) because
> .getTables() acts like I quoted the MY_TABLE identifier.
> It's quite annoying to create a table and not be able to see it...
> Tested with postgresql-server.i686 8.0.7-1PGDG and 8.2dev-503
> Maybe this is a server-side issue?
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
In response to
pgsql-jdbc by date
|Next:||From: Marc Herbert||Date: 2006-07-21 14:19:29|
|Subject: Re: DatabaseMetaData.getTables() is silently quoting table identifiers?|
|Previous:||From: Marc Herbert||Date: 2006-07-20 18:52:49|
|Subject: "prepared" statements (Re: Limit vs setMaxRows issue)|