Skip site navigation (1) Skip section navigation (2)

DatabaseMetaData.getTables() is silently quoting table identifiers?

From: Marc Herbert <Marc(dot)Herbert(at)continuent(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: DatabaseMetaData.getTables() is silently quoting table identifiers?
Date: 2006-07-20 16:21:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

 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?




pgsql-jdbc by date

Next:From: Marc HerbertDate: 2006-07-20 18:52:49
Subject: "prepared" statements (Re: Limit vs setMaxRows issue)
Previous:From: Dave CramerDate: 2006-07-18 17:25:16
Subject: Re: Prepared Statement Memory Size

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group