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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2005-11-25 18:22:09 | SQLJ, any plans? |
Previous Message | Thomas Kellerer | 2005-11-25 16:34:31 | getTables() not working for information_schema or pg_catalog |