Adding column comment to information_schema.columns

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
*** 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,