Message-ID: <40E37E3F.2050400@telstra.net>
Date: Thu, 01 Jul 2004 13:00:15 +1000
From: Justin Clift <jc@telstra.net>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.1) Gecko/20040406
MIME-Version: 1.0
To: PostgreSQL Hackers Mailing List <pgsql-hackers@postgresql.org>
Subject: Adding column comment to information_schema.columns
Content-Type: multipart/mixed; boundary="------------090004010004040702040508"

This is a multi-part message in MIME format.
--------------090004010004040702040508
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Hi all,

Not sure how worthwhile others will find this small patch (to CVS HEAD), 
but we found it useful.  It adds the column comments to the 
information_schema.columns view.

Hope it's useful.

:-)

Regards and best wishes,

Justin Clift

--------------090004010004040702040508
Content-Type: text/plain;
 name="postgresql_column_comment.diff"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
 filename="postgresql_column_comment.diff"

*** information_schema.sql.orig	2004-07-01 11:59:26.000000000 +1000
--- information_schema.sql	2004-07-01 12:33:01.000000000 +1000
***************
*** 442,448 ****
  
             CAST(null AS cardinal_number) AS maximum_cardinality,
             CAST(a.attnum AS sql_identifier) AS dtd_identifier,
!            CAST('NO' AS character_data) AS is_self_referencing
  
      FROM (pg_attribute a LEFT JOIN pg_attrdef ad ON attrelid = adrelid AND attnum = adnum),
           pg_class c, pg_namespace nc, pg_user u,
--- 442,450 ----
  
             CAST(null AS cardinal_number) AS maximum_cardinality,
             CAST(a.attnum AS sql_identifier) AS dtd_identifier,
!            CAST('NO' AS character_data) AS is_self_referencing,
! 
!            col_description(a.attrelid, a.attnum) AS column_comment
  
      FROM (pg_attribute a LEFT JOIN pg_attrdef ad ON attrelid = adrelid AND attnum = adnum),
           pg_class c, pg_namespace nc, pg_user u,

--------------090004010004040702040508--