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

Re: Getting views' metadata

From: Kris Jurka <books(at)ejurka(dot)com>
To: Gaël BOUGANNE <gael(dot)bouganne(at)univ-nantes(dot)fr>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Getting views' metadata
Date: 2009-06-10 22:53:20
Message-ID: alpine.BSO.2.00.0906101852170.24632@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

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

Attachment: ViewMD.java
Description: text/plain (1.1 KB)

In response to

pgsql-jdbc by date

Next:From: Achilleas MantziosDate: 2009-06-11 09:04:12
Subject: Re: R: Re: Applet & SSL
Previous:From: Kris JurkaDate: 2009-06-10 14:32:39
Subject: Re: Random crashes on getConnection

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