Postgres Pro
Downloads
Home   >   mailing lists

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

From Katalina Marcos
Subject Re: table and column's comments
Date
Msg-id 000701c4abf2$44c17160$770210ac@kmarcos
Whole thread Raw
In response to Re: table and column's comments  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Tree view 
Ok...

Thanks for your replay
Kata

-----Mensaje original-----
De: Oliver Jowett [mailto:oliver@opencloud.com]
Enviado el: miércoles, 06 de octubre de 2004 17:11
Para: kmarcos@mazda.com.co
CC: pgsql-jdbc@postgresql.org
Asunto: Re: [JDBC] table and column's comments

Katalina Marcos wrote:

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

You can't get at the comments via the standard interface; it has no
provision for them. The label fields are apparently intended for output
formatting, not for comment display. See the discussion at:

   http://archives.postgresql.org/pgsql-jdbc/2004-07/msg00314.php
   http://archives.postgresql.org/pgsql-jdbc/2004-08/msg00008.php

If you need to get at the comments, you'll need to do a
postgresql-specific query.

-O

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Translation updates: errors_ru.properties
Next
From: Oliver Jowett
Date:
Subject: Re: Postgres 8.0 + JDBC