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

Re: 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: Re: getTables() not working for information_schema or pg_catalog
Date: 2005-11-25 20:48:01
Message-ID: dm7ta0$675$1@sea.gmane.org (view raw or flat)
Thread:
Lists: pgsql-jdbc
[getTables() not returning information about pg_catalog and 
information_schema]

Dave Cramer wrote on 25.11.2005 18:58:
> 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.

But then I wouldn't expect them to be included in the list that is 
returned from getSchemas() as well. If they should be hidden for JDBC 
access (which is a strange decision in my opinion) then they should be 
hidden completely.

Regards
Thomas


In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2005-11-25 22:42:58
Subject: Re: getTables() not working for information_schema or pg_catalog
Previous:From: Jaime CasanovaDate: 2005-11-25 18:22:09
Subject: SQLJ, any plans?

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