getTables() not working for information_schema or pg_catalog - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject getTables() not working for information_schema or pg_catalog
Date
Msg-id dm7eel$q6f$1@sea.gmane.org
Whole thread Raw
Responses Re: getTables() not working for information_schema or pg_catalog  (Dave Cramer <pg@fastcrypt.com>)
Re: getTables() not working for information_schema or pg_catalog  (Kris Jurka <books@ejurka.com>)
List 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

pgsql-jdbc by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Log the sql query ?
Next
From: Dave Cramer
Date:
Subject: Re: getTables() not working for information_schema or pg_catalog