Postgres Pro
Downloads
Home   >   mailing lists

Re: DatabaseMetaData.getTables() is silently quoting table identifiers? - Mailing list pgsql-jdbc

From Marc Herbert
Subject Re: DatabaseMetaData.getTables() is silently quoting table identifiers?
Date
Msg-id khjirlrghvy.fsf@meije.emic.fr
Whole thread Raw
In response to DatabaseMetaData.getTables() is silently quoting table identifiers?  (Marc Herbert <Marc.Herbert@continuent.com>)
List pgsql-jdbc
Tree view 
Marc Herbert <Marc.Herbert@continuent.com> writes:

> 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?


I finally did my archeology homework:

Date: 2002-10-27 09:39:54 GMT
Subject: DatabaseMetaData.getTables() problem

<http://comments.gmane.org/gmane.comp.db.postgresql.jdbc/1614>

pgsql-jdbc by date:

Previous
From: Mark Lewis
Date:
Subject: Re: DatabaseMetaData.getTables() is silently quoting table
Next
From: "Michael Guyver"
Date:
Subject: Trouble with CallableStatement