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

Re: 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: Re: DatabaseMetaData.getTables() is silently quoting table identifiers?
Date: 2006-07-21 14:19:29
Message-ID: khjirlrghvy.fsf@meije.emic.fr (view raw or flat)
Thread:
Lists: pgsql-jdbc
Marc Herbert <Marc(dot)Herbert(at)continuent(dot)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>



In response to

pgsql-jdbc by date

Next:From: Michael GuyverDate: 2006-07-23 00:55:42
Subject: Trouble with CallableStatement
Previous:From: Mark LewisDate: 2006-07-20 20:13:11
Subject: Re: DatabaseMetaData.getTables() is silently quoting table

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