table and column's comments - Mailing list pgsql-jdbc

From Katalina Marcos
Subject table and column's comments
Date
Msg-id 000001c4abee$11f40f30$770210ac@kmarcos
Whole thread Raw
Responses Re: table and column's comments
Re: table and column's comments
List pgsql-jdbc

Hi all!

 

I want to ask you if I can retrieve table’s comment and column’s comments whit ResultSetMetaData in pgjdbc.

 

I did prove with a simple query ("select * from ca_t_nivel where 1=0") but table name is empty and column label is the same column name… I did use pg74.213.jdbc3.jar, my output:

 

table name

column number: 1

column name: tpl_nivel_conshist

column label: tpl_nivel_conshist

column type: 4

column classname: java.lang.Integer

column display size: 11

column number: 2

column name: td_nivel_fechoper

column label: td_nivel_fechoper

column type: 93

column classname: java.sql.Timestamp

column display size: 22

 

I’ve searched in mail list but I didn’t found much about it…

 

Thanks in advance…

Kata

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: errors.properties fixes and translation update
Next
From: Oliver Jowett
Date:
Subject: Re: table and column's comments