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,
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
