getTables() not working for information_schema or pg_catalog

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: getTables() not working for information_schema or pg_catalog
Date: 2005-11-25 16:34:31
Message-ID: dm7eel$q6f$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello,

I just stumbled across something:

When I call

con.getMetaData().getTables(null, "information_schema", "%", null);

(where con is a java.sql.Connection), I would assume to get all tables
that are stored in the information_schema, but the returned ResultSet is
empty (next() immediately returns false).

The same is true when I call it with "pg_catalog"
Passing null for the table name does not make a difference.

getTables(null, "public", "%", null) is working fine.

Am I missing something, or is this broken?

I am using postgresql-8.1-404.jdbc3.jar and PG 8.1 on a Windows 2000 box
(with JDK 1.5)

Regards
Thomas

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2005-11-25 17:58:25 Re: getTables() not working for information_schema or pg_catalog
Previous Message Jaime Casanova 2005-11-25 14:32:59 Re: Log the sql query ?