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

Getting views' metadata

From: Gaël BOUGANNE <gael(dot)bouganne(at)univ-nantes(dot)fr>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Getting views' metadata
Date: 2009-06-09 11:53:32
Message-ID: 4A2E4D3C.6040908@univ-nantes.fr (view raw or flat)
Thread:
Lists: pgsql-jdbc
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

Responses

pgsql-jdbc by date

Next:From: Albe LaurenzDate: 2009-06-09 16:30:58
Subject: Re: [Patch] Binary Transfer v12
Previous:From: Dan EvansDate: 2009-06-08 14:41:05
Subject: Re: getColumnDisplayWidth() returns 0x7fffffff for char varying

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