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)
pgsql-jdbc by date
|Next:||From: Dave Cramer||Date: 2005-11-25 17:58:25|
|Subject: Re: getTables() not working for information_schema or pg_catalog|
|Previous:||From: Jaime Casanova||Date: 2005-11-25 14:32:59|
|Subject: Re: Log the sql query ?|