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

Re: getTables() not working for information_schema or pg_catalog

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: getTables() not working for information_schema or pg_catalog
Date: 2005-11-25 17:58:25
Message-ID: 72441723-6002-42DB-B8A9-CEDF16801F4E@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
IIRC these two tables are excluded on purpose to avoid returning  
those tables. The purpose of getTables is to get the tables  
associated with the connection, not to get system tables.

Dave

On 25-Nov-05, at 11:34 AM, Thomas Kellerer wrote:

> 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
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>


In response to

Responses

pgsql-jdbc by date

Next:From: Jaime CasanovaDate: 2005-11-25 18:22:09
Subject: SQLJ, any plans?
Previous:From: Thomas KellererDate: 2005-11-25 16:34:31
Subject: getTables() not working for information_schema or pg_catalog

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