From: | "Katalina Marcos" <kmarcos(at)mazda(dot)com(dot)co> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | table and column's comments |
Date: | 2004-10-06 21:47:26 |
Message-ID: | 000001c4abee$11f40f30$770210ac@kmarcos |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2004-10-06 22:11:14 | Re: table and column's comments |
Previous Message | Oliver Jowett | 2004-10-06 21:11:22 | Re: Avoiding explicit addDataType calls for PostGIS |