Обсуждение: Getting views' metadata

Hi,

i'm trying to retrieve complete metadata of my pgsql 8.3 database using
JDBC.
But i got a problem getting the columns informations of views.
I succesfully get the view names using 'getTables(...)' method, but when
calling 'getColumns(...)' for a given view, the returned ResultSet is empty.

So i wonder wether it is possible to get such information or not. If it
is possible how shall i do?

Regards,

Gaël BOUGANNE

On Tue, 9 Jun 2009, Ga?l BOUGANNE wrote:

> i'm trying to retrieve complete metadata of my pgsql 8.3 database using
> JDBC. But i got a problem getting the columns informations of views. I
> succesfully get the view names using 'getTables(...)' method, but when
> calling 'getColumns(...)' for a given view, the returned ResultSet is
> empty.

It certainly works for me (as attached).  If you can produce a similar
counterexample which doesn't work, I'll certainly try and figure out
what's wrong.

Kris Jurka