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

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 (view raw or flat)
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

pgsql-jdbc by date

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

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